APPS.PYCADAR_PKG dependencies on HR_ASSIGNMENT_SET

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

226:
227: sqlstr := 'select
228: distinct paf.person_id
229: from
230: hr_assignment_set_amendments hasa,
231: per_all_assignments_f paf,
232: pay_payroll_actions ppa
233: where
234: ppa.payroll_action_id = :PACTID and

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

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

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

Line 861: lv_ass_set_on := hr_assignment_set.assignment_in_set(

857: /* Added this code for Assignment set validation bug#3438254,
858: Otherwise it was displaying all the assignments that are
859: not in the given Assignment Set.
860: */
861: lv_ass_set_on := hr_assignment_set.assignment_in_set(
862: l_asg_set_id,
863: ln_assignment_id);
864: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);
865:

Line 1067: lv_ass_set_on := hr_assignment_set.assignment_in_set(

1063: open c_non_void_pymts(ln_dd_action_id); /* Bug 16387461 sbachu*/
1064: fetch c_non_void_pymts into lc_nv_flag;
1065: if c_non_void_pymts%found then
1066:
1067: lv_ass_set_on := hr_assignment_set.assignment_in_set(
1068: ln_asg_set_id,
1069: ln_assignment_id);
1070: hr_utility.trace('lv_ass_set_on : '||lv_ass_set_on);
1071:

Line 1318: ,hr_assignment_set_amendments hasa

1314: ,pai.action_context_id
1315: FROM pay_assignment_actions paa
1316: ,pay_payroll_actions ppa
1317: ,hr_lookups hrl
1318: ,hr_assignment_set_amendments hasa
1319: ,pay_action_information pai
1320: ,per_time_periods ptp
1321: WHERE ppa.effective_Date BETWEEN c_start_date
1322: AND c_end_date

Line 1353: FROM hr_assignment_set_amendments

1349: --
1350: CURSOR csr_inc_exc(c_assignment_set_id NUMBER
1351: ,c_assignment_id NUMBER) IS
1352: SELECT include_or_exclude
1353: FROM hr_assignment_set_amendments
1354: WHERE assignment_set_id = c_assignment_set_id
1355: AND assignment_id = nvl(c_assignment_id,assignment_id);
1356: --
1357: --