APPS.PAY_MX_PAYREG_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 250: FROM hr_assignment_set_amendments hasa ,

246: ppa.action_type,
247: ppa.effective_date,
248: act.source_action_id,
249: nvl(ppa.start_date,ppa.effective_date)
250: FROM hr_assignment_set_amendments hasa ,
251: per_assignments_f paf ,
252: pay_assignment_actions act ,
253: pay_payroll_actions ppa ,
254: pay_payrolls_f ppf

Line 476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;

472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
473: l_person_id per_all_assignments_f.person_id%TYPE;
474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
475: l_organization_id per_all_assignments_f.organization_id%TYPE;
476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
477: cp_start_date pay_payroll_actions.effective_date%TYPE;
478: cp_effective_date pay_payroll_actions.effective_date%TYPE;
479: l_run_eff_date DATE;
480: run_action_type VARCHAR2(30);