APPS.PQP_USTIAA_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 58: pay_assignment_actions act_run,

54:
55:
56: sqlstr := 'select distinct asg.person_id
57: from per_assignments_f asg,
58: pay_assignment_actions act_run,
59: pay_payroll_actions ppa_run,
60: pay_payroll_actions ppa_gen
61: where ppa_gen.payroll_action_id = :payroll_action_id
62: and ppa_run.action_type in (''R'',''Q'',''V'',''B'')

Line 116: pay_assignment_actions act_run,

112: asg.assignment_id ,
113: act_run.tax_unit_id
114: FROM per_assignments_f asg,
115: pay_payroll_actions ppa_run,
116: pay_assignment_actions act_run,
117: pay_payroll_actions ppa_gen
118: WHERE
119: ppa_gen.payroll_action_id = pactid
120: AND ppa_run.effective_date BETWEEN ppa_gen.start_date

Line 206: SELECT pay_assignment_actions_s.nextval

202: num := num + 1;
203: END IF;
204: EXIT WHEN c_actions%NOTFOUND;
205:
206: SELECT pay_assignment_actions_s.nextval
207: INTO lockingactid
208: FROM dual;
209: -- Insert a record into pay_assignment_actions and pay_action_interlocks
210: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);

Line 209: -- Insert a record into pay_assignment_actions and pay_action_interlocks

205:
206: SELECT pay_assignment_actions_s.nextval
207: INTO lockingactid
208: FROM dual;
209: -- Insert a record into pay_assignment_actions and pay_action_interlocks
210: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
211: hr_nonrun_asact.insint(lockingactid,lockedactid);
212:
213: /* The following code is commented bug 4343076

Line 255: from pay_assignment_actions paa1,

251: l_proc_name VARCHAR2(150) := g_proc_name ||'sort_action';
252: BEGIN
253: hr_utility.set_location('Entering : '||l_proc_name, 10);
254: sqlstr := 'select paa1.rowid
255: from pay_assignment_actions paa1,
256: pay_payroll_actions ppa1
257: where ppa1.payroll_action_id = :pactid
258: and paa1.payroll_action_id = ppa1.payroll_action_id
259: order by paa1.assignment_id,paa1.assignment_action_id

Line 331: pay_assignment_actions act_run,

327: max(act_run.assignment_action_id),
328: asg.assignment_id
329: FROM per_assignments_f asg,
330: pay_payroll_actions ppa_run,
331: pay_assignment_actions act_run,
332: pay_payroll_actions ppa_gen
333: WHERE
334: ppa_gen.payroll_action_id = pactid
335: AND ppa_run.effective_date BETWEEN ppa_gen.start_date

Line 428: SELECT pay_assignment_actions_s.nextval

424: LOOP
425: FETCH c_actions_ops INTO lockedactid,assignid;
426: IF c_actions_ops%FOUND THEN
427:
428: SELECT pay_assignment_actions_s.nextval
429: INTO lockingactid
430: FROM dual;
431: -- Insert a record into pay_temp_object_actions
432: hr_nonrun_asact.insact(lockingactid =>lockingactid,

Line 811: pay_assignment_actions paa,

807: paa.assignment_action_id act_id,
808: ppa_run.effective_date pay_date,
809: paa.tax_unit_id tax_unit_id
810: from pay_payroll_actions ppa_gen,
811: pay_assignment_actions paa,
812: pay_payroll_actions ppa_run,
813: pay_temp_object_actions poa
814: where poa.object_action_id = p_assactid
815: and poa.payroll_action_id = ppa_gen.payroll_action_id