APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_ACTION_CONTEXTS

Line 991: and exists ( select 'X' from pay_action_contexts pac, ff_contexts fc

987: where hoi.org_information_context = 'Canada Employer Identification'
988: and hoi.org_information2 = l_pre_org_id
989: and hoi.org_information5 = 'T4A/RL2')
990: AND PPY.payroll_id = ASG.payroll_id
991: and exists ( select 'X' from pay_action_contexts pac, ff_contexts fc
992: where pac.assignment_id = asg.assignment_id
993: and pac.context_id = fc.context_id
994: and fc.context_name = 'JURISDICTION_CODE'
995: and pac.context_value = 'QC' )

Line 1029: from pay_action_contexts pac,

1025: AND asg.assignment_type = 'E'
1026: AND ppa.effective_date between asg.effective_start_date
1027: and asg.effective_end_date
1028: AND EXISTS (select 1
1029: from pay_action_contexts pac,
1030: ff_contexts fc
1031: where pac.assignment_id = paa.assignment_id
1032: and pac.assignment_action_id = paa.assignment_action_id
1033: and pac.context_id = fc.context_id

Line 1069: from pay_action_contexts pac,

1065: AND asg.assignment_type = 'E'
1066: AND ppa.effective_date between asg.effective_start_date
1067: and asg.effective_end_date
1068: AND EXISTS (select 1
1069: from pay_action_contexts pac,
1070: ff_contexts fc
1071: where pac.assignment_id = paa.assignment_id
1072: and pac.assignment_action_id = paa.assignment_action_id
1073: and pac.context_id = fc.context_id

Line 2158: pay_action_contexts pac1,

2154: per_all_assignments_f paf,
2155: per_all_people_f ppf,
2156: pay_payroll_actions ppa,
2157: pay_action_classifications pac,
2158: pay_action_contexts pac1,
2159: ff_contexts fc
2160: where ppf.person_id = cp_person_id
2161: and paf.person_id = ppf.person_id
2162: and paa.assignment_id = paf.assignment_id

Line 2741: pay_action_contexts pac1,

2737: per_all_assignments_f paf,
2738: per_all_people_f ppf,
2739: pay_payroll_actions ppa,
2740: pay_action_classifications pac,
2741: pay_action_contexts pac1,
2742: ff_contexts fc
2743: where ppf.person_id = cp_person_id
2744: and paf.person_id = ppf.person_id
2745: and paa.assignment_id = paf.assignment_id

Line 4114: from pay_action_contexts pac,

4110: and asg.assignment_type = ''E''
4111: and ppa.payroll_id = ppy.payroll_id
4112: and ppy.business_group_id = '||to_char(l_business_group)||'
4113: and exists (select 1
4114: from pay_action_contexts pac,
4115: ff_contexts fc
4116: where pac.assignment_id = paa.assignment_id
4117: and pac.assignment_action_id = paa.assignment_action_id
4118: and pac.context_id = fc.context_id