APPS.PQP_EXPPREPROC_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 50: pay_assignment_actions act_run, /* run and quickpay assignment actions */

46: l_temp_date );
47:
48: sqlstr := 'select distinct asg.person_id
49: from per_assignments_f asg,
50: pay_assignment_actions act_run, /* run and quickpay assignment actions */
51: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
52: pay_payroll_actions ppa_gen /* PYUGEN information */
53: where ppa_gen.payroll_action_id = :payroll_action_id
54: and ppa_run.action_type in (''R'',''Q'',''V'')

Line 116: pay_assignment_actions act_run, /* run and quickpay assignment actions */

112: MAX(act_run.assignment_action_id),
113: asg.assignment_id
114: FROM per_assignments_f asg,
115: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
116: pay_assignment_actions act_run, /* run and quickpay assignment actions */
117: pay_payroll_actions ppa_gen, /* PYUGEN information */
118: per_time_periods ptp
119: WHERE ppa_gen.payroll_action_id = pactid
120: --Added by Gattu

Line 207: select pay_assignment_actions_s.nextval

203: --
204:
205:
206: hr_utility.set_location('procpyr',3);
207: select pay_assignment_actions_s.nextval
208: into lockingactid
209: from dual;
210: --
211: -- insert the action record.

Line 232: from pay_assignment_actions paa1, -- PYUGEN assignment action

228:
229: BEGIN
230:
231: sqlstr := 'select paa1.rowid
232: from pay_assignment_actions paa1, -- PYUGEN assignment action
233: pay_payroll_actions ppa1 -- PYUGEN payroll action id
234: where ppa1.payroll_action_id = :pactid
235: and paa1.payroll_action_id = ppa1.payroll_action_id
236: order by paa1.assignment_action_id for update of paa1.assignment_id';