APPS.PAY_KR_YEA_PDF_PKG dependencies on PER_ASSIGNMENTS_F

Line 238: per_assignments_f pa

234: pp.employee_number emp_num
235: from per_kr_assignment_yea_info pkayi,
236: per_people_f pp,
237: per_periods_of_service ppos,
238: per_assignments_f pa
239: where pa.business_group_id + 0 = g_business_group_id
240: and pa.establishment_id = nvl(g_business_place_id,pa.establishment_id)
241: and decode(to_char(nvl(g_assignment_set_id,-1)),
242: '-1','Y',

Line 2831: from per_assignments_f pa,

2827: 'T','4',
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

Line 2844: ,per_assignments_f pa

2840: between pcr_pp.effective_start_date and pcr_pp.effective_end_date
2841: UNION ALL
2842: select ppf.national_identifier, '0' code
2843: from per_people_f ppf
2844: ,per_assignments_f pa
2845: where pa.person_id = ppf.person_id
2846: and pa.assignment_id = p_assignment_id
2847: and g_target_eoy between pa.effective_start_date and pa.effective_end_date
2848: and g_target_eoy between ppf.effective_start_date and ppf.effective_end_date

Line 2860: from per_assignments_f pa,

2856: select code contact_type
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

Line 2873: ,per_assignments_f pa

2869: and pcr.cont_information2 = 'Y'
2870: UNION ALL
2871: select ppf.national_identifier, '0' code
2872: from per_people_f ppf
2873: ,per_assignments_f pa
2874: where pa.person_id = ppf.person_id
2875: and pa.assignment_id = p_assignment_id
2876: and g_target_eoy between pa.effective_start_date and pa.effective_end_date
2877: and g_target_eoy between ppf.effective_start_date and ppf.effective_end_date)

Line 2898: from per_assignments_f pa,

2894: 'T','4',
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

Line 7007: per_assignments_f pa,

7003: substrb(pp.national_identifier,1,6) res_reg_num,
7004: pp.employee_number emp_num
7005: from per_people_f pp,
7006: per_periods_of_service ppos,
7007: per_assignments_f pa,
7008: hr_organization_information hoi,
7009: per_business_groups_perf pbg
7010: where pbg.legislation_code = c_legislation_code
7011: and pbg.business_group_id = nvl(g_business_group_id,pbg.business_group_id)