[Home] [Help]
832: from per_all_assignments_f a,
833: pay_assignment_actions paa,
834: pay_payroll_actions ppa,
835: pay_all_payrolls_f pay,
836: hr_soft_coding_keyflex flex
837: ,(SELECT a2.assignment_id, max(a2.effective_start_date) max_effective_start_date -- Bug 9292092
838: FROM per_all_assignments_f a2,
839: per_assignment_status_types past
840: WHERE /* a2.assignment_id = a.assignment_id
1224: oi.ORG_INFORMATION4,
1225: ass.ASSIGNMENT_ID
1226: from hr_organization_information oi,
1227: pay_payrolls_f roll,
1228: hr_soft_coding_keyflex flex,
1229: per_assignments_f ass,
1230: fnd_sessions sess
1231: where oi.ORG_INFORMATION_CONTEXT = 'Tax Details References'
1232: and roll.business_group_id + 0 = oi.organization_id
1284: c_effective_end_date in date) is
1285: select scl.segment1
1286: from per_all_assignments_f paf,
1287: pay_all_payrolls_f ppf,
1288: hr_soft_coding_keyflex scl
1289: where paf.assignment_id = c_assignment_id
1290: and paf.payroll_id = ppf.payroll_id
1291: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id
1292: and c_effective_end_date between
1350: c_effective_end_date in date) is
1351: select scl.segment1
1352: from per_all_assignments_f paf,
1353: pay_all_payrolls_f ppf,
1354: hr_soft_coding_keyflex scl
1355: where paf.assignment_id = c_assignment_id
1356: and paf.payroll_id = ppf.payroll_id
1357: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id
1358: and c_effective_end_date between
1946: select 1 from dual where exists
1947: (select scl.segment1
1948: from per_all_assignments_f paf,
1949: pay_all_payrolls_f ppf,
1950: hr_soft_coding_keyflex scl
1951: where paf.assignment_id = c_assignment_id
1952: and paf.payroll_id = ppf.payroll_id
1953: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id
1954: and scl.segment1 <> c_tax_ref
2236: select a.assignment_id,
2237: a.effective_end_date
2238: from per_all_assignments_f a,
2239: pay_all_payrolls_f pay,
2240: hr_soft_coding_keyflex flex,
2241: per_periods_of_service serv
2242: where a.person_id = c_person_id
2243: and flex.segment1 = c_tax_ref
2244: and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2288: per_assignment_status_types past,
2289: pay_all_payrolls_f ppf,
2290: per_time_periods ptp,
2291: per_periods_of_service serv,
2292: hr_soft_coding_keyflex flex
2293: WHERE a.person_id BETWEEN stperson AND endperson
2294: AND a.business_group_id +0 = g_business_group_id
2295: AND (g_payroll_id is null
2296: or
2347: per_assignment_status_types past,
2348: pay_all_payrolls_f ppf,
2349: per_time_periods ptp,
2350: per_periods_of_service serv,
2351: hr_soft_coding_keyflex flex
2352: WHERE p.person_id = ppr.person_id
2353: AND ppr.chunk_number = chunk
2354: AND ppr.payroll_action_id = pactid
2355: AND a.business_group_id +0 = g_business_group_id
4840: Cursor csr_get_paye_ref(c_assignment_id NUMBER, c_effective_date DATE) IS
4841: SELECT flex.segment1 paye_ref, paaf.period_of_service_id
4842: FROM per_all_assignments_f paaf,
4843: pay_all_payrolls_f papf,
4844: hr_soft_coding_keyflex flex
4845: WHERE paaf.assignment_id = c_assignment_id
4846: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date
4847: AND paaf.payroll_id = papf.payroll_id
4848: AND c_effective_date BETWEEN papf.effective_start_date and papf.effective_end_date
4928: l_agg_paye_flag per_all_people_f.per_information10%type;
4929: l_found BOOLEAN;
4930: l_dummy NUMBER;
4931:
4932: l_agg_paye_reference hr_soft_coding_keyflex.segment1%type;
4933: l_paye_reference hr_soft_coding_keyflex.segment1%type;
4934: l_period_of_service_id number;
4935: l_agg_period_of_service_id number;
4936: l_action_sequence number;
4929: l_found BOOLEAN;
4930: l_dummy NUMBER;
4931:
4932: l_agg_paye_reference hr_soft_coding_keyflex.segment1%type;
4933: l_paye_reference hr_soft_coding_keyflex.segment1%type;
4934: l_period_of_service_id number;
4935: l_agg_period_of_service_id number;
4936: l_action_sequence number;
4937: