APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on HR_ASSIGNMENT_SETS

Line 740: hr_assignment_sets has,

736: pay_payroll_actions ppa_mag,
737: pay_org_payment_methods_f popm,
738: pay_all_payrolls_f ppf,
739: per_all_assignments_f paf2,
740: hr_assignment_sets has,
741: hr_assignment_set_amendments hasa
742: where ppa_dar.payroll_action_id = pactid
743: and has.assignment_set_id = p_assignment_set_id
744: and ppa_mag.effective_date between

Line 860: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;

856: ln_prev_source_action_id NUMBER := null;
857:
858: ln_master_action_id NUMBER;
859:
860: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
861:
862: ld_deposit_start_date DATE;
863: ld_deposit_end_date DATE;
864: ln_payroll_id NUMBER;