Human Capital Management - EBS (MOSC)

MOSC Banner

apps.hr_phone_api.create_phone does not insert all data

 hi again, following my earlier thread:

Need help with hr create phone procedure

the query I am using in the cursor below fetches 280 records.

select
--per.EMPLOYEE_NUMBER emp_no
per.PARTY_ID --party
,per.PERSON_ID --person
,tmp.TELEPHONE phone
from
PER_PEOPLE_F PER,
PER_ASSIGNMENTS_F PA,
temp_emp_phone tmp
where
PER.PERSON_ID = pa.PERSON_ID
and per.BUSINESS_GROUP_ID 81
and pa.EFFECTIVE_END_DATE >= sysdate
and per.EFFECTIVE_END_DATE >= sysdate
and tmp.EMP_NO = per.EMPLOYEE_NUMBER

but somehow when i run the procedure I get only 16 records inserted to the per_phones

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center