APPS.PYCADAR_PKG dependencies on HR_ASSIGNMENT_SETS

Line 169: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;

165: --
166: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
167: l_payroll_id number;
168: -- leg_param pay_payroll_actions.legislative_parameters%type;
169: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
170:
171: --Bug 3331023
172: l_db_version varchar2(20);
173: -- Bug#4338254

Line 467: hr_assignment_sets has,

463: per_periods_of_service pos,
464: pay_payroll_actions ppa_dar,
465: pay_payroll_actions ppa_mag,
466: pay_all_payrolls_f ppf,
467: hr_assignment_sets has,
468: hr_assignment_set_amendments hasa
469: where ppa_dar.payroll_action_id = pactid
470: and has.assignment_set_id = p_assignment_set_id
471: and ppa_mag.effective_date between

Line 576: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;

572: ln_deposit_action_id NUMBER;
573: ln_assignment_id NUMBER;
574: ln_tax_unit_id NUMBER;
575: --
576: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
577: --
578: /* Removed cur_leg_param cursor to use get_payroll_action bug#3438254 */
579:
580: -- Bug#4338254