DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_MTRA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 201: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

197: l_tax_office_name hr_organization_units.name%TYPE ;
198: l_employer_ba pay_external_accounts.segment3%TYPE ;
199: l_employer_pay_meth_id hr_organization_information.org_information1%TYPE ;
200: l_tax_office_id hr_organization_information.organization_id%TYPE ;
201: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
202: l_counter number := 0;
203: l_archive VARCHAR2(3);
204: l_reporting_date DATE;
205: l_termination_date date;

Line 394: pay_assignment_actions act,

390: prepaid_action_id, appa.effective_date, appa.payroll_action_id,
391: appa2.payroll_action_id payactid, hsck.segment2 local_unit_id
392: from pay_payroll_actions appa,
393: pay_payroll_actions appa2,
394: pay_assignment_actions act,
395: pay_assignment_actions act1,
396: pay_action_interlocks pai,
397: per_all_assignments_f paaf,
398: hr_soft_coding_keyflex hsck,

Line 395: pay_assignment_actions act1,

391: appa2.payroll_action_id payactid, hsck.segment2 local_unit_id
392: from pay_payroll_actions appa,
393: pay_payroll_actions appa2,
394: pay_assignment_actions act,
395: pay_assignment_actions act1,
396: pay_action_interlocks pai,
397: per_all_assignments_f paaf,
398: hr_soft_coding_keyflex hsck,
399: hr_organization_information hoi--,