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

Line 36: pay_assignment_actions paa,

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

Line 76: pay_assignment_actions paa,

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

Line 105: pay_assignment_actions passt

101: AND NOT EXISTS
102: (SELECT pail.locked_action_id
103: FROM pay_action_interlocks pail,
104: pay_payroll_actions pact,
105: pay_assignment_actions passt
106: WHERE pact.report_type IN ('T4A_AMEND_MAG','MAG_T4A','CAEOY_T4A_AMEND_PP')
107: AND pact.payroll_action_id = passt.payroll_action_id
108: AND passt.assignment_action_id = pail.locking_action_id
109: AND pail.locked_action_id = paa.assignment_action_id)

Line 126: pay_assignment_actions paa

122: ppa.report_type,
123: paa.assignment_action_id
124: FROM
125: pay_payroll_actions ppa,
126: pay_assignment_actions paa
127: WHERE ppa.report_type IN ( 'T4A_AMEND_MAG' , 'MAG_T4A' )
128: AND ppa.action_type = 'X'
129: AND ppa.action_status = 'C'
130: AND ppa.business_group_id = cp_business_group_id

Line 142: pay_assignment_actions passt

138: pail.locked_action_id
139: FROM
140: pay_action_interlocks pail,
141: pay_payroll_actions pact,
142: pay_assignment_actions passt
143: WHERE pact.report_type IN ( 'T4A_AMEND_MAG' , 'MAG_T4A' , 'CAEOY_T4A_AMEND_PP' )
144: AND pact.payroll_action_id = passt.payroll_action_id
145: AND passt.assignment_action_id = pail.locking_action_id
146: AND pail.locked_action_id = paa.assignment_action_id )

Line 172: FROM pay_assignment_actions

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

Line 187: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;--

183: l_tax_unit_id NUMBER;
184: lockingactid NUMBER;
185: -- ln_primary_assignment_id NUMBER := 0;
186: lv_report_type pay_payroll_actions.report_type%TYPE ;
187: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;--
188: -- ln_gre_id_null NUMBER;
189: -- ln_iteration NUMBER := 0;
190: -- lv_full_name per_people_f.full_name%TYPE;
191: -- lv_employee_number per_people_f.employee_number%TYPE;

Line 197: -- l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;

193: -- lv_record_name VARCHAR2(100);
194: lv_fed_amend_flag VARCHAR2(5);
195: ln_t4a_amend_flag_ue_id NUMBER;
196: lv_flag_count NUMBER := 0;
197: -- l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;
198: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
199:
200: BEGIN
201: hr_utility.trace('+=========================================================+');

Line 198: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;

194: lv_fed_amend_flag VARCHAR2(5);
195: ln_t4a_amend_flag_ue_id NUMBER;
196: lv_flag_count NUMBER := 0;
197: -- l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;
198: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
199:
200: BEGIN
201: hr_utility.trace('+=========================================================+');
202: hr_utility.set_location( 'pay_ca_t4a_amend_mag.action_creation',10);

Line 239: SELECT pay_assignment_actions_s.nextval

235: hr_utility.trace('Person ID : '|| to_char(l_person_id));
236: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
237: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
238: hr_utility.trace('x------------------------------------------------x');
239: SELECT pay_assignment_actions_s.nextval
240: INTO lockingactid
241: FROM dual;
242: hr_utility.trace('New T4A Amend Action = ' ||to_char(lockingactid));
243:

Line 254: -- Insert into pay_assignment_actions.

250: EXIT when c_get_fed_amend_flag%NOTFOUND;
251: hr_utility.trace('Amended : '||lv_fed_amend_flag);
252: IF c_get_fed_amend_flag%FOUND THEN
253: IF lv_fed_amend_flag = 'Y' AND lv_flag_count =0 THEN
254: -- Insert into pay_assignment_actions.
255: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 80);
256: hr_nonrun_asact.insact(lockingactid
257: ,l_assignment_id
258: ,p_pactid

Line 262: UPDATE pay_assignment_actions aa

258: ,p_pactid
259: ,p_chunk
260: ,l_tax_unit_id);
261: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 90);
262: UPDATE pay_assignment_actions aa
263: SET aa.serial_number = to_char(l_person_id)
264: WHERE aa.assignment_action_id = lockingactid;
265:
266: -- hr_utility.set_location('pay_ca_t4a_amend_mag.action_creation', 100);

Line 374: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;

370: l_trans_bus_no VARCHAR2(240) ;
371: l_bus_no VARCHAR2(240) ;
372: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
373: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
374: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
375: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
376: l_acc_info_flag CHAR(1);
377: l_trans_name VARCHAR2(240);
378: l_gre_name VARCHAR2(240);

Line 375: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

371: l_bus_no VARCHAR2(240) ;
372: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
373: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
374: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
375: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
376: l_acc_info_flag CHAR(1);
377: l_trans_name VARCHAR2(240);
378: l_gre_name VARCHAR2(240);
379: l_bg_id NUMBER;

Line 1289: FROM pay_assignment_actions paa,

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

Line 1303: pay_assignment_actions

1299: CURSOR c_get_person_id(p_mag_asg_action_id NUMBER) IS
1300: SELECT
1301: serial_number
1302: FROM
1303: pay_assignment_actions
1304: WHERE assignment_action_id = p_mag_asg_action_id;
1305:
1306: BEGIN
1307: hr_utility.trace('+==========================================================+');