APPS.PYCADAR_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

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 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 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: --