APPS.PAY_NEGBAL_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 223: pay_assignment_actions paa,

219: ppa.effective_date effective_end_date,
220: sr.jurisdiction_code jurisdiction_code
221: FROM hr_organization_information hoi,
222: pay_payroll_actions ppa,
223: pay_assignment_actions paa,
224: pay_state_rules sr,
225: per_assignments_f asg,
226: pay_payroll_actions ppa_arch
227: WHERE ppa_arch.payroll_action_id = pactid

Line 238: pay_assignment_actions paa1,

234: AND (paa.action_sequence,asg.person_id,paa.tax_unit_id)
235: in (select max(paa1.action_sequence),paf1.person_id, paa1.tax_unit_id
236: from pay_action_classifications pac,
237: pay_payroll_actions ppa1,
238: pay_assignment_actions paa1,
239: per_assignments_f paf1
240: where paf1.person_id = asg.person_id
241: AND paf1.business_group_id + 0 = ppa_arch.business_group_id
242: AND paf1.assignment_type = 'E'

Line 384: select pay_assignment_actions_s.nextval

380: report_person_on_tape(assignid,l_period_start,l_period_end,
381: l_state, effdt,transmitter_code)) then
382:
383: hr_utility.set_location('pay_negbal_pkg.procngb',7);
384: select pay_assignment_actions_s.nextval
385: into lockingactid
386: from dual;
387: -- insert the action record.
388: hr_utility.set_location('pay_negbal_pkg.procngb',8);

Line 416: pay_assignment_actions paa,

412:
413: hr_utility.set_location('pay_negbal_pkg.sort_action',1);
414: sqlstr := 'select paa.rowid
415: from pay_payroll_actions ppa,
416: pay_assignment_actions paa,
417: per_all_assignments_f paf, -- #1894165
418: hr_organization_units hou,
419: hr_organization_units hou1
420: where ppa.payroll_action_id = :pactid