apps.hr_phone_api.create_phone does not insert all data
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