eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_YEA_PDF_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 2832: per_contact_relationships pcr,

2828: 'BROTHER','5',
2829: 'SISTER','5',
2830: '6')) code
2831: from per_assignments_f pa,
2832: per_contact_relationships pcr,
2833: per_people_f pcr_pp
2834: where pa.assignment_id = p_assignment_id
2835: and g_target_eoy
2836: between pa.effective_start_date and pa.effective_end_date

Line 2861: per_contact_relationships pcr,

2857: from (select pcr_pp.national_identifier,
2858: decode(nvl(cont_information11,
2859: decode(contact_type, 'S','3','P','1','B','5','SISTER','5' ,'A','4','C','4','R','4','O','4','T','4','6')),'1','4','5','5','4','3','3','2','7','3','2','4','6') code
2860: from per_assignments_f pa,
2861: per_contact_relationships pcr,
2862: per_people_f pcr_pp
2863: where pa.assignment_id = p_assignment_id
2864: and g_target_eoy between pa.effective_start_date and pa.effective_end_date
2865: and pcr.person_id = pa.person_id

Line 2899: per_contact_relationships pcr,

2895: 'BROTHER','5',
2896: 'SISTER','5',
2897: '6')) code
2898: from per_assignments_f pa,
2899: per_contact_relationships pcr,
2900: per_people_f pcr_pp
2901: where pa.assignment_id = p_assignment_id
2902: and g_target_eoy
2903: between pa.effective_start_date and pa.effective_end_date

Line 3765: per_contact_relationships pcr,

3761: cursor csr_pcr_dpnt
3762: is
3763: select pcr.contact_relationship_id
3764: from per_all_assignments_f pa,
3765: per_contact_relationships pcr,
3766: per_all_people_f pp_con
3767: where pa.assignment_id = p_assignment_id
3768: and p_effective_date
3769: between pa.effective_start_date and pa.effective_end_date