APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on HR_ASSIGNMENT_SETS

Line 730: hr_assignment_sets has,

726: pay_payroll_actions ppa_mag,
727: pay_org_payment_methods_f popm,
728: pay_all_payrolls_f ppf,
729: per_all_assignments_f paf2,
730: hr_assignment_sets has,
731: hr_assignment_set_amendments hasa
732: where ppa_dar.payroll_action_id = pactid
733: and has.assignment_set_id = p_assignment_set_id
734: and ppa_mag.effective_date between

Line 850: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;

846: ln_prev_source_action_id NUMBER := null;
847:
848: ln_master_action_id NUMBER;
849:
850: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
851:
852: ld_deposit_start_date DATE;
853: ld_deposit_end_date DATE;
854: ln_payroll_id NUMBER;