APPS.PYCADAR_PKG dependencies on HR_ASSIGNMENT_SETS

Line 193: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;

189: --
190: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
191: l_payroll_id number;
192: -- leg_param pay_payroll_actions.legislative_parameters%type;
193: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
194:
195: --Bug 3331023
196: l_db_version varchar2(20);
197: -- Bug#4338254

Line 504: hr_assignment_sets has,

500: per_periods_of_service pos,
501: pay_payroll_actions ppa_dar,
502: pay_payroll_actions ppa_mag,
503: pay_all_payrolls_f ppf,
504: hr_assignment_sets has,
505: hr_assignment_set_amendments hasa
506: where ppa_dar.payroll_action_id = pactid
507: and has.assignment_set_id = p_assignment_set_id
508: and ppa_mag.effective_date between

Line 613: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;

609: ln_deposit_action_id NUMBER;
610: ln_assignment_id NUMBER;
611: ln_tax_unit_id NUMBER;
612: --
613: l_asg_set_id hr_assignment_sets.assignment_set_id%TYPE;
614: --
615: /* Removed cur_leg_param cursor to use get_payroll_action bug#3438254 */
616:
617: -- Bug#4338254