APPS.PYCADAR_PKG dependencies on HR_ASSIGNMENT_SET

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 206: hr_assignment_set_amendments hasa,

202:
203: sqlstr := 'select
204: distinct paf.person_id
205: from
206: hr_assignment_set_amendments hasa,
207: per_all_assignments_f paf,
208: pay_payroll_actions ppa
209: where
210: ppa.payroll_action_id = :PACTID and

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 468: hr_assignment_set_amendments hasa

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
472: ppa_dar.start_date and ppa_dar.effective_date

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

Line 824: lv_ass_set_on := hr_assignment_set.assignment_in_set(

820: /* Added this code for Assignment set validation bug#3438254,
821: Otherwise it was displaying all the assignments that are
822: not in the given Assignment Set.
823: */
824: lv_ass_set_on := hr_assignment_set.assignment_in_set(
825: l_asg_set_id,
826: ln_assignment_id);
827: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);
828:

Line 993: lv_ass_set_on := hr_assignment_set.assignment_in_set(

989: ln_assignment_id,
990: ln_tax_unit_id;
991: exit WHEN c_paid_actions%NOTFOUND;
992:
993: lv_ass_set_on := hr_assignment_set.assignment_in_set(
994: ln_asg_set_id,
995: ln_assignment_id);
996: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);
997: