APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_ACTION_CONTEXTS

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

1039: where hoi.org_information_context = 'Canada Employer Identification'
1040: and hoi.org_information2 = l_pre_organization_id))
1041: )
1042: AND PPY.payroll_id = ASG.payroll_id
1043: and exists ( select 'X' from pay_action_contexts pac, ff_contexts fc
1044: where pac.assignment_id = asg.assignment_id
1045: and pac.context_id = fc.context_id
1046: and fc.context_name = 'JURISDICTION_CODE'
1047: and pac.context_value = 'QC' )

Line 1078: from pay_action_contexts pac,

1074: AND asg.assignment_type = 'E'
1075: AND ppa.effective_date between asg.effective_start_date
1076: and asg.effective_end_date
1077: AND EXISTS (select 1
1078: from pay_action_contexts pac,
1079: ff_contexts fc
1080: where pac.assignment_id = paa.assignment_id
1081: and pac.assignment_action_id = paa.assignment_action_id
1082: and pac.context_id = fc.context_id

Line 2192: from pay_action_contexts pac

2188: assignment_id . Take it from pay_action_context table. */
2189:
2190: cursor c_get_province is
2191: select distinct context_value
2192: from pay_action_contexts pac
2193: where pac.assignment_id = l_asgid;
2194:
2195: cursor c_footnote_info(p_balance_name varchar2) is
2196: select distinct pet.element_information19,

Line 2294: from pay_action_contexts pac,ff_contexts ffc

2290: between to_char(all_paf.effective_start_date,'YYYY')
2291: and to_char(all_paf.effective_end_date,'YYYY')
2292: and run_paa.assignment_id = all_paf.assignment_id
2293: and exists (select 1
2294: from pay_action_contexts pac,ff_contexts ffc
2295: where ffc.context_name = 'JURISDICTION_CODE'
2296: and pac.context_id = ffc.context_id
2297: and pac.assignment_id = run_paa.assignment_id
2298: and pac.context_value = 'QC');

Line 2344: pay_action_contexts pac1,

2340: per_all_assignments_f paf,
2341: per_all_people_f ppf,
2342: pay_payroll_actions ppa,
2343: pay_action_classifications pac,
2344: pay_action_contexts pac1,
2345: ff_contexts fc
2346: where ppf.person_id = cp_person_id
2347: and paf.person_id = ppf.person_id
2348: and paf.assignment_id = paa.assignment_id

Line 4125: from pay_action_contexts pac,

4121: and asg.assignment_type = ''E''
4122: and ppa.payroll_id = ppy.payroll_id
4123: and ppy.business_group_id = '||to_char(l_business_group)||'
4124: and exists (select 1
4125: from pay_action_contexts pac,
4126: ff_contexts fc
4127: where pac.assignment_id = paa.assignment_id
4128: and pac.assignment_action_id = paa.assignment_action_id
4129: and pac.context_id = fc.context_id