APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_ACTION_CONTEXTS

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

920: where hoi.org_information_context = 'Canada Employer Identification'
921: and hoi.org_information2 = l_pre_org_id
922: and hoi.org_information5 = 'T4A/RL2')
923: AND PPY.payroll_id = ASG.payroll_id
924: and exists ( select 'X' from pay_action_contexts pac, ff_contexts fc
925: where pac.assignment_id = asg.assignment_id
926: and pac.context_id = fc.context_id
927: and fc.context_name = 'JURISDICTION_CODE'
928: and pac.context_value = 'QC' )

Line 962: from pay_action_contexts pac,

958: AND asg.assignment_type = 'E'
959: AND ppa.effective_date between asg.effective_start_date
960: and asg.effective_end_date
961: AND EXISTS (select 1
962: from pay_action_contexts pac,
963: ff_contexts fc
964: where pac.assignment_id = paa.assignment_id
965: and pac.assignment_action_id = paa.assignment_action_id
966: and pac.context_id = fc.context_id

Line 2035: pay_action_contexts pac1,

2031: per_all_assignments_f paf,
2032: per_all_people_f ppf,
2033: pay_payroll_actions ppa,
2034: pay_action_classifications pac,
2035: pay_action_contexts pac1,
2036: ff_contexts fc
2037: where ppf.person_id = cp_person_id
2038: and paf.person_id = ppf.person_id
2039: and paa.assignment_id = paf.assignment_id

Line 3267: from pay_action_contexts pac,

3263: and asg.assignment_type = ''E''
3264: and ppa.payroll_id = ppy.payroll_id
3265: and ppy.business_group_id = '||to_char(l_business_group)||'
3266: and exists (select 1
3267: from pay_action_contexts pac,
3268: ff_contexts fc
3269: where pac.assignment_id = paa.assignment_id
3270: and pac.assignment_action_id = paa.assignment_action_id
3271: and pac.context_id = fc.context_id