APPS.PAY_ES_TWR_CALC_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 90: FROM per_contact_relationships pcr

86: ,pcr.contact_type
87: ,NVL(pcr.cont_information1,'N') fiscal_dependent
88: ,NVL(pcr.cont_information2,'N') single_parent
89: ,pcr.date_start date_start
90: FROM per_contact_relationships pcr
91: ,per_all_people_f pap
92: ,per_All_assignments_f paaf
93: WHERE paaf.assignment_id = passignment_id
94: AND pcr.person_id = paaf.person_id

Line 370: l_fiscal_dependent per_contact_relationships.cont_information1%TYPE;

366: AND paaf.effective_end_date;
367: --
368: l_marital_status per_all_people_f.marital_status%TYPE;
369: l_person_id per_all_people_f.person_id%TYPE;
370: l_fiscal_dependent per_contact_relationships.cont_information1%TYPE;
371: l_marital_status_desc VARCHAR2(80);
372: --
373: BEGIN
374: --

Line 411: FROM per_contact_relationships pcr

407: ,peffective_date DATE ) RETURN VARCHAR2 IS
408: --
409: CURSOR c_spouse_info IS
410: SELECT cont_information1
411: FROM per_contact_relationships pcr
412: WHERE pcr.person_id = pperson_id
413: AND pcr.contact_type = 'S' --Spouse
414: AND pcr.cont_information_category = 'ES'
415: AND peffective_date BETWEEN nvl(pcr.date_start,START_OF_TIME)

Line 418: l_fiscal_dependent per_contact_relationships.cont_information1%TYPE;

414: AND pcr.cont_information_category = 'ES'
415: AND peffective_date BETWEEN nvl(pcr.date_start,START_OF_TIME)
416: AND nvl(pcr.date_end,END_OF_TIME);
417: --
418: l_fiscal_dependent per_contact_relationships.cont_information1%TYPE;
419: --
420: BEGIN
421: OPEN c_spouse_info;
422: FETCH c_spouse_info INTO l_fiscal_dependent;