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_CA_EOY_RL1_ARCHIVE dependencies on PAY_ACTION_CONTEXTS

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

1135: where hoi.org_information_context = 'Canada Employer Identification'
1136: and hoi.org_information2 = l_pre_organization_id))
1137: )
1138: AND PPY.payroll_id = ASG.payroll_id
1139: and exists ( select 'X' from pay_action_contexts pac, ff_contexts fc
1140: where pac.assignment_id = asg.assignment_id
1141: and pac.context_id = fc.context_id
1142: and fc.context_name = 'JURISDICTION_CODE'
1143: and pac.context_value = 'QC' )

Line 1174: from pay_action_contexts pac,

1170: AND asg.assignment_type = 'E'
1171: AND ppa.effective_date between asg.effective_start_date
1172: and asg.effective_end_date
1173: AND EXISTS (select 1
1174: from pay_action_contexts pac,
1175: ff_contexts fc
1176: where pac.assignment_id = paa.assignment_id
1177: and pac.assignment_action_id = paa.assignment_action_id
1178: and pac.context_id = fc.context_id

Line 1214: from pay_action_contexts pac,

1210: AND asg.assignment_type = 'E'
1211: AND ppa.effective_date between asg.effective_start_date
1212: and asg.effective_end_date
1213: AND EXISTS (select 1
1214: from pay_action_contexts pac,
1215: ff_contexts fc
1216: where pac.assignment_id = paa.assignment_id
1217: and pac.assignment_action_id = paa.assignment_action_id
1218: and pac.context_id = fc.context_id

Line 2473: pay_action_contexts pac1,

2469: per_all_assignments_f paf,
2470: pay_assignment_actions paa,
2471: pay_payroll_actions ppa,
2472: pay_action_classifications pac,
2473: pay_action_contexts pac1,
2474: ff_contexts fc
2475: where ppf.person_id = cp_person_id
2476: and paf.person_id = ppf.person_id
2477: and paf.assignment_id = paa.assignment_id

Line 3014: from pay_action_contexts pac

3010: assignment_id . Take it from pay_action_context table. */
3011:
3012: cursor c_get_province is
3013: select distinct context_value
3014: from pay_action_contexts pac
3015: where pac.assignment_id = l_asgid;
3016:
3017: cursor c_footnote_info(p_balance_name varchar2) is
3018: select distinct pet.element_information19,

Line 3119: from pay_action_contexts pac,ff_contexts ffc

3115: between all_paf.effective_start_date
3116: and all_paf.effective_end_date
3117: and run_paa.assignment_id = all_paf.assignment_id
3118: and exists (select 1
3119: from pay_action_contexts pac,ff_contexts ffc
3120: where ffc.context_name = 'JURISDICTION_CODE'
3121: and pac.context_id + 0 = ffc.context_id
3122: and pac.assignment_id = run_paa.assignment_id
3123: and pac.context_value = 'QC')

Line 3189: pay_action_contexts pac1,

3185: per_all_assignments_f paf,
3186: pay_assignment_actions paa,
3187: pay_payroll_actions ppa,
3188: pay_action_classifications pac,
3189: pay_action_contexts pac1,
3190: ff_contexts fc
3191: where ppf.person_id = cp_person_id
3192: and paf.person_id = ppf.person_id
3193: and paf.assignment_id = paa.assignment_id

Line 5150: from pay_action_contexts pac,

5146: and asg.assignment_type = ''E''
5147: and ppa.payroll_id = ppy.payroll_id
5148: and ppy.business_group_id = '||to_char(l_business_group)||'
5149: and exists (select 1
5150: from pay_action_contexts pac,
5151: ff_contexts fc
5152: where pac.assignment_id = paa.assignment_id
5153: and pac.assignment_action_id = paa.assignment_action_id
5154: and pac.context_id = fc.context_id