DBA Data[Home] [Help]

APPS.PAY_ES_CALC_SS_EARNINGS dependencies on PER_CONTACT_RELATIONSHIPS

Line 240: FROM per_contact_relationships pcr

236: ,peffective_date IN DATE)RETURN NUMBER IS
237: --
238: CURSOR c_contact_info IS
239: SELECT COUNT(pcr.contact_type)
240: FROM per_contact_relationships pcr
241: ,per_all_assignments_f paaf
242: WHERE paaf.assignment_id = passignment_id
243: AND pcr.person_id = paaf.person_id
244: AND pcr.rltd_per_rsds_w_dsgntr_flag = 'Y'