[Home] [Help]
737: pay_org_payment_methods_f popm,
738: pay_all_payrolls_f ppf,
739: per_all_assignments_f paf2,
740: hr_assignment_sets has,
741: hr_assignment_set_amendments hasa
742: where ppa_dar.payroll_action_id = pactid
743: and has.assignment_set_id = p_assignment_set_id
744: and ppa_mag.effective_date between
745: ppa_dar.start_date and ppa_dar.effective_date
1216: ,pai.action_context_id
1217: FROM pay_assignment_actions paa
1218: ,pay_payroll_actions ppa
1219: ,hr_lookups hrl
1220: ,hr_assignment_set_amendments hasa
1221: ,pay_action_information pai
1222: ,per_time_periods ptp
1223: WHERE ppa.effective_Date BETWEEN c_start_date
1224: AND c_end_date
1251: --
1252: CURSOR csr_inc_exc(c_assignment_set_id NUMBER
1253: ,c_assignment_id NUMBER) IS
1254: SELECT include_or_exclude
1255: FROM hr_assignment_set_amendments
1256: WHERE assignment_set_id = c_assignment_set_id
1257: AND assignment_id = nvl(c_assignment_id,assignment_id);
1258: --
1259: --
1488: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1489: from pay_assignment_actions paa,
1490: pay_payroll_actions ppa,
1491: per_assignments_f paf,
1492: hr_assignment_set_amendments hasa
1493: where :payroll_action_id is not null
1494: and ppa.action_type in (''R'',''Q'')
1495: and paa.assignment_id = paf.assignment_id
1496: and ppa.consolidation_set_id = ' || ln_consolidation_set_id
1523: lv_sqlstr := 'select '||l_db_version||' distinct paf.person_id
1524: from pay_assignment_actions paa,
1525: pay_payroll_actions ppa,
1526: per_assignments_f paf,
1527: hr_assignment_set_amendments hasa
1528: where :payroll_action_id is not null
1529: and ppa.action_type in (''R'',''Q'')
1530: and paa.assignment_id = paf.assignment_id
1531: and ppa.consolidation_set_id = ' || ln_consolidation_set_id