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_T4_CANCEL_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 17: pay_assignment_actions paa

13: p_sqlstr := 'select distinct paaf.person_id
14: from per_all_assignments_f paaf,
15: pay_payroll_actions ppa,
16: pay_payroll_actions ppa1,
17: pay_assignment_actions paa
18: where ppa.payroll_action_id = paa.payroll_action_id
19: and paa.assignment_id = paaf.assignment_id
20: and ppa1.payroll_action_id = :payroll_action_id
21: and ppa.payroll_action_id =

Line 54: pay_assignment_actions paa,

50: from per_all_assignments_f paaf,
51: pay_payroll_actions ppa,
52: pay_payroll_actions ppa1,
53: pay_payroll_actions ppa2,
54: pay_assignment_actions paa,
55: pay_assignment_actions paa1,
56: pay_action_interlocks int
57: where ppa.payroll_action_id = paa.payroll_action_id
58: and paa.assignment_id = paaf.assignment_id

Line 55: pay_assignment_actions paa1,

51: pay_payroll_actions ppa,
52: pay_payroll_actions ppa1,
53: pay_payroll_actions ppa2,
54: pay_assignment_actions paa,
55: pay_assignment_actions paa1,
56: pay_action_interlocks int
57: where ppa.payroll_action_id = paa.payroll_action_id
58: and paa.assignment_id = paaf.assignment_id
59: and ppa1.payroll_action_id = p_pactid

Line 72: from pay_action_interlocks pai, pay_assignment_actions paa2

68: and paa.action_status = 'C'
69: and paa1.action_status = 'C'
70: and paa.assignment_action_id
71: not in (select paa2.assignment_action_id
72: from pay_action_interlocks pai, pay_assignment_actions paa2
73: where paa2.assignment_action_id = pai.locked_action_id
74: and paa2.payroll_action_id =
75: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
76: )

Line 95: pay_assignment_actions paa,

91: per_all_assignments_f paaf,
92: pay_payroll_actions ppa,
93: pay_payroll_actions ppa1,
94: pay_payroll_actions ppa2,
95: pay_assignment_actions paa,
96: pay_assignment_actions paa1,
97: pay_action_interlocks int
98: where
99: ppa.payroll_action_id = paa.payroll_action_id

Line 96: pay_assignment_actions paa1,

92: pay_payroll_actions ppa,
93: pay_payroll_actions ppa1,
94: pay_payroll_actions ppa2,
95: pay_assignment_actions paa,
96: pay_assignment_actions paa1,
97: pay_action_interlocks int
98: where
99: ppa.payroll_action_id = paa.payroll_action_id
100: and paa.assignment_id = paaf.assignment_id

Line 122: pay_assignment_actions paa2

118: and paf.person_id = paaf.person_id)
119: and paa.assignment_action_id
120: not in (select paa2.assignment_action_id
121: from pay_action_interlocks pai,
122: pay_assignment_actions paa2
123: where paa2.assignment_action_id = pai.locked_action_id
124: and paa2.payroll_action_id =
125: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
126: )

Line 139: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

135: l_report_type pay_payroll_actions.report_type%TYPE;
136: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
137: l_person_id per_all_people_f.person_id%TYPE;
138: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
139: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
140: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
141: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
142: lv_report_type pay_payroll_actions.report_type%TYPE ;
143: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

Line 140: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

136: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
137: l_person_id per_all_people_f.person_id%TYPE;
138: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
139: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
140: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
141: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
142: lv_report_type pay_payroll_actions.report_type%TYPE ;
143: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
144: lv_fed_amend_flag ff_archive_items.value%TYPE;

Line 141: lockingactid pay_assignment_actions.assignment_action_id%TYPE;

137: l_person_id per_all_people_f.person_id%TYPE;
138: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
139: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
140: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
141: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
142: lv_report_type pay_payroll_actions.report_type%TYPE ;
143: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
144: lv_fed_amend_flag ff_archive_items.value%TYPE;
145: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;

Line 143: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

139: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
140: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
141: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
142: lv_report_type pay_payroll_actions.report_type%TYPE ;
143: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
144: lv_fed_amend_flag ff_archive_items.value%TYPE;
145: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
146: lv_flag_count NUMBER := 0;
147: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;

Line 147: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;

143: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
144: lv_fed_amend_flag ff_archive_items.value%TYPE;
145: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
146: lv_flag_count NUMBER := 0;
147: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
148: l_payroll_act NUMBER;
149:
150: BEGIN
151: hr_utility.trace('+=========================================================+');

Line 205: SELECT pay_assignment_actions_s.nextval

201: hr_utility.trace('Person ID : '|| to_char(l_person_id));
202: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
203: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
204: hr_utility.trace('x------------------------------------------------x');
205: SELECT pay_assignment_actions_s.nextval
206: INTO lockingactid
207: FROM dual;
208: hr_utility.trace('New T4 Cancel Action = ' ||to_char(lockingactid));
209: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 30);

Line 217: UPDATE pay_assignment_actions aa

213: ,p_chunk
214: ,l_tax_unit_id);
215: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 40);
216:
217: UPDATE pay_assignment_actions aa
218: SET aa.serial_number = to_char(l_person_id)
219: WHERE aa.assignment_action_id = lockingactid;
220:
221: hr_utility.set_location('pay_ca_t4_cancel_mag.action_creation', 50);

Line 291: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;

287: l_trans_bus_no ff_archive_items.value%TYPE;
288: l_bus_no ff_archive_items.value%TYPE;
289: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
290: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
291: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
292: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
293: l_acc_info_flag CHAR(1);
294: l_trans_name ff_archive_items.value%TYPE;
295: l_gre_name ff_archive_items.value%TYPE;

Line 292: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

288: l_bus_no ff_archive_items.value%TYPE;
289: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
290: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
291: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
292: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
293: l_acc_info_flag CHAR(1);
294: l_trans_name ff_archive_items.value%TYPE;
295: l_gre_name ff_archive_items.value%TYPE;
296: l_bg_id pay_payroll_actions.business_group_id%TYPE;

Line 697: from pay_assignment_actions paa,

693:
694: begin
695: select max(paa1.payroll_action_id)
696: into l_context1
697: from pay_assignment_actions paa,
698: pay_assignment_actions paa1,
699: pay_action_interlocks int,
700: pay_payroll_actions ppa
701: where int.locking_action_id = paa.assignment_action_id

Line 698: pay_assignment_actions paa1,

694: begin
695: select max(paa1.payroll_action_id)
696: into l_context1
697: from pay_assignment_actions paa,
698: pay_assignment_actions paa1,
699: pay_action_interlocks int,
700: pay_payroll_actions ppa
701: where int.locking_action_id = paa.assignment_action_id
702: and paa1.assignment_action_id = int.locked_action_id

Line 1152: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;

1148: l_mag_asg_action_id NUMBER;
1149: l_jurisdiction_code ff_archive_items.value%TYPE;
1150: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1151: || fnd_global.local_chr(10);
1152: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1153: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1154: l_arch_report_type pay_payroll_actions.report_type%TYPE;
1155: -- l_asg_id NUMBER;
1156: l_neg_bal_exists BOOLEAN := FALSE;

Line 1153: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;

1149: l_jurisdiction_code ff_archive_items.value%TYPE;
1150: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1151: || fnd_global.local_chr(10);
1152: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1153: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1154: l_arch_report_type pay_payroll_actions.report_type%TYPE;
1155: -- l_asg_id NUMBER;
1156: l_neg_bal_exists BOOLEAN := FALSE;
1157: l_person_id per_people_f.person_id%TYPE;

Line 1234: FROM pay_assignment_actions paa,

1230: CURSOR c_get_payroll_asg_actid(p_assg_actid NUMBER) IS
1231: SELECT
1232: paa.assignment_action_id,
1233: paa.payroll_action_id
1234: FROM pay_assignment_actions paa,
1235: pay_payroll_actions ppa,
1236: pay_action_interlocks pai,
1237: pay_action_interlocks pai2
1238: WHERE pai.locking_action_id = p_assg_actid

Line 1250: pay_assignment_actions

1246: CURSOR c_get_person_id(p_mag_asg_action_id NUMBER) IS
1247: SELECT
1248: serial_number
1249: FROM
1250: pay_assignment_actions
1251: WHERE assignment_action_id = p_mag_asg_action_id;
1252: ----
1253: CURSOR c_get_t4_ei_earn_display(p_aa_id IN NUMBER) IS
1254: SELECT

Line 1289: pay_assignment_actions paa,

1285: CURSOR c_get_report_type(p_arch_action_id IN NUMBER) IS
1286: SELECT
1287: ppa.report_type
1288: FROM
1289: pay_assignment_actions paa,
1290: pay_payroll_actions ppa
1291: WHERE paa.assignment_action_id = p_arch_action_id
1292: AND paa.payroll_action_id = ppa.payroll_action_id;
1293: ----