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 118: pay_assignment_actions act_run, /* run and quickpay assignment actions */

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

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

177: MAX(act_run.assignment_action_id),
178: asg.assignment_id
179: FROM per_assignments_f asg,
180: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
181: pay_assignment_actions act_run, /* run and quickpay assignment actions */
182: pay_payroll_actions ppa_gen, /* PYUGEN information */
183: per_time_periods ptp
184: WHERE ppa_gen.payroll_action_id = pactid
185: --Added by Gattu

Line 272: select pay_assignment_actions_s.nextval

268: exit when c_actions%notfound;
269:
270: --
271: hr_utility.set_location('procpyr',3);
272: select pay_assignment_actions_s.nextval
273: into lockingactid
274: from dual;
275: --
276: -- insert the action record.

Line 295: select pay_assignment_actions_s.nextval

291: exit when c_actions_with_payroll%notfound;
292:
293: --
294: hr_utility.set_location('procpyr',3);
295: select pay_assignment_actions_s.nextval
296: into lockingactid
297: from dual;
298: --
299: -- insert the action record.

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

317:
318: BEGIN
319:
320: sqlstr := 'select paa1.rowid
321: from pay_assignment_actions paa1, -- PYUGEN assignment action
322: pay_payroll_actions ppa1 -- PYUGEN payroll action id
323: where ppa1.payroll_action_id = :pactid
324: and paa1.payroll_action_id = ppa1.payroll_action_id
325: order by paa1.assignment_action_id for update of paa1.assignment_id';