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

Line 34: pay_assignment_actions paa,

30: --
31: p_sqlstr := 'SELECT DISTINCT to_number(fai1.value)
32: FROM ff_archive_items fai1,
33: ff_archive_items fai2,
34: pay_assignment_actions paa,
35: pay_payroll_actions ppa,
36: pay_payroll_actions ppa1
37: WHERE ppa1.payroll_action_id = :p_pactid
38: AND ppa.report_type = ''CAEOY_T4_AMEND_PP''

Line 74: pay_assignment_actions paa,

70: paa.tax_unit_id,
71: paf.effective_end_date,
72: MAX(paa.assignment_action_id)
73: FROM pay_payroll_actions ppa,
74: pay_assignment_actions paa,
75: per_all_assignments_f paf,
76: pay_payroll_actions ppa1,
77: hr_organization_information hoi1
78: WHERE ppa1.payroll_action_id = p_pactid

Line 103: pay_assignment_actions passt

99: AND NOT EXISTS
100: (SELECT pail.locked_action_id
101: FROM pay_action_interlocks pail,
102: pay_payroll_actions pact,
103: pay_assignment_actions passt
104: WHERE pact.report_type IN ('T4_AMEND_MAG','PYT4MAG','CAEOY_T4_AMEND_PP')
105: AND pact.payroll_action_id = passt.payroll_action_id
106: AND passt.assignment_action_id = pail.locking_action_id
107: AND pail.locked_action_id = paa.assignment_action_id)

Line 124: pay_assignment_actions paa

120: ppa.report_type,
121: paa.assignment_action_id
122: FROM
123: pay_payroll_actions ppa,
124: pay_assignment_actions paa
125: WHERE ppa.report_type IN ( 'T4_AMEND_MAG' , 'PYT4MAG' )
126: AND ppa.action_type = 'X'
127: AND ppa.action_status = 'C'
128: AND ppa.business_group_id = cp_business_group_id

Line 140: pay_assignment_actions passt

136: pail.locked_action_id
137: FROM
138: pay_action_interlocks pail,
139: pay_payroll_actions pact,
140: pay_assignment_actions passt
141: WHERE pact.report_type IN ( 'T4_AMEND_MAG' , 'PYT4MAG' , 'CAEOY_T4_AMEND_PP' )
142: AND pact.payroll_action_id = passt.payroll_action_id
143: AND passt.assignment_action_id = pail.locking_action_id
144: AND pail.locked_action_id = paa.assignment_action_id )

Line 170: FROM pay_assignment_actions

166: WHERE user_name = cp_user_name;
167: -----
168: CURSOR c_lockingactid_check (cp_locking_asg_act_id IN NUMBER) IS
169: SELECT assignment_action_id
170: FROM pay_assignment_actions
171: WHERE assignment_action_id = cp_locking_asg_act_id;
172: -----
173: l_year_end DATE;
174: l_effective_end_date DATE;

Line 179: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

175: l_report_type pay_payroll_actions.report_type%TYPE;
176: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
177: l_person_id per_all_people_f.person_id%TYPE;
178: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
179: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
180: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
181: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
182: lv_report_type pay_payroll_actions.report_type%TYPE ;
183: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

Line 180: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

176: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
177: l_person_id per_all_people_f.person_id%TYPE;
178: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
179: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
180: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
181: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
182: lv_report_type pay_payroll_actions.report_type%TYPE ;
183: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
184: lv_fed_amend_flag ff_archive_items.value%TYPE;

Line 181: lockingactid pay_assignment_actions.assignment_action_id%TYPE;

177: l_person_id per_all_people_f.person_id%TYPE;
178: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
179: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
180: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
181: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
182: lv_report_type pay_payroll_actions.report_type%TYPE ;
183: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
184: lv_fed_amend_flag ff_archive_items.value%TYPE;
185: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;

Line 183: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

179: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
180: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
181: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
182: lv_report_type pay_payroll_actions.report_type%TYPE ;
183: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
184: lv_fed_amend_flag ff_archive_items.value%TYPE;
185: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
186: lv_flag_count NUMBER := 0;
187: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;

Line 187: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;

183: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
184: lv_fed_amend_flag ff_archive_items.value%TYPE;
185: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
186: lv_flag_count NUMBER := 0;
187: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
188:
189: BEGIN
190: hr_utility.trace('+=========================================================+');
191: hr_utility.set_location( 'pay_ca_t4_amend_mag.action_creation',10);

Line 228: SELECT pay_assignment_actions_s.nextval

224: ' Person: '|| to_char(l_person_id)||
225: ' Tax Unit: '|| to_char(l_tax_unit_id)||
226: ' End Date: '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
227:
228: SELECT pay_assignment_actions_s.nextval
229: INTO lockingactid
230: FROM dual;
231: hr_utility.trace('New T4 Amend Action = ' ||to_char(lockingactid));
232:

Line 243: -- Insert into pay_assignment_actions.

239: EXIT when c_get_fed_amend_flag%NOTFOUND;
240: hr_utility.trace('Amended : '||lv_fed_amend_flag);
241: IF c_get_fed_amend_flag%FOUND THEN
242: IF lv_fed_amend_flag = 'Y' AND lv_flag_count =0 THEN
243: -- Insert into pay_assignment_actions.
244: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 80);
245: hr_nonrun_asact.insact(lockingactid
246: ,l_assignment_id
247: ,p_pactid

Line 251: UPDATE pay_assignment_actions aa

247: ,p_pactid
248: ,p_chunk
249: ,l_tax_unit_id);
250: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 90);
251: UPDATE pay_assignment_actions aa
252: SET aa.serial_number = to_char(l_person_id)
253: WHERE aa.assignment_action_id = lockingactid;
254:
255: -- hr_utility.set_location('pay_ca_t4_amend_mag.action_creation', 100);

Line 363: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;

359: l_trans_bus_no ff_archive_items.value%TYPE;
360: l_bus_no ff_archive_items.value%TYPE;
361: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
362: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
363: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
364: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
365: l_acc_info_flag CHAR(1);
366: l_trans_name ff_archive_items.value%TYPE;
367: l_gre_name ff_archive_items.value%TYPE;

Line 364: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

360: l_bus_no ff_archive_items.value%TYPE;
361: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
362: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
363: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
364: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
365: l_acc_info_flag CHAR(1);
366: l_trans_name ff_archive_items.value%TYPE;
367: l_gre_name ff_archive_items.value%TYPE;
368: l_bg_id pay_payroll_actions.business_group_id%TYPE;

Line 1207: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;

1203: l_mag_asg_action_id NUMBER;
1204: l_jurisdiction_code ff_archive_items.value%TYPE;
1205: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1206: || fnd_global.local_chr(10);
1207: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1208: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1209: -- l_asg_id NUMBER;
1210: l_neg_bal_exists BOOLEAN := FALSE;
1211: l_person_id per_people_f.person_id%TYPE;

Line 1208: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;

1204: l_jurisdiction_code ff_archive_items.value%TYPE;
1205: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1206: || fnd_global.local_chr(10);
1207: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1208: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1209: -- l_asg_id NUMBER;
1210: l_neg_bal_exists BOOLEAN := FALSE;
1211: l_person_id per_people_f.person_id%TYPE;
1212: l_address_line1 per_addresses.address_line1%TYPE;

Line 1288: FROM pay_assignment_actions paa,

1284: CURSOR c_get_payroll_asg_actid(p_assg_actid NUMBER) IS
1285: SELECT
1286: paa.assignment_action_id,
1287: paa.payroll_action_id
1288: FROM pay_assignment_actions paa,
1289: pay_payroll_actions ppa,
1290: pay_action_interlocks pai
1291: WHERE pai.locking_action_id = p_assg_actid
1292: AND pai.locked_action_id = paa.assignment_action_id

Line 1302: pay_assignment_actions

1298: CURSOR c_get_person_id(p_mag_asg_action_id NUMBER) IS
1299: SELECT
1300: serial_number
1301: FROM
1302: pay_assignment_actions
1303: WHERE assignment_action_id = p_mag_asg_action_id;
1304: ----
1305: CURSOR c_get_t4_ei_earn_display(p_aa_id IN NUMBER) IS
1306: SELECT