[Home] [Help]
767: from per_all_assignments_f a,
768: pay_assignment_actions paa,
769: pay_payroll_actions ppa,
770: pay_all_payrolls_f pay,
771: hr_soft_coding_keyflex flex
772: where a.person_id = c_person_id
773: and paa.assignment_id = a.assignment_id
774: and ppa.payroll_action_id = paa.payroll_action_id
775: -- and pay.payroll_id = a.payroll_id
1117: oi.ORG_INFORMATION4,
1118: ass.ASSIGNMENT_ID
1119: from hr_organization_information oi,
1120: pay_payrolls_f roll,
1121: hr_soft_coding_keyflex flex,
1122: per_assignments_f ass,
1123: fnd_sessions sess
1124: where oi.ORG_INFORMATION_CONTEXT = 'Tax Details References'
1125: and roll.business_group_id + 0 = oi.organization_id
1177: c_effective_end_date in date) is
1178: select scl.segment1
1179: from per_all_assignments_f paf,
1180: pay_all_payrolls_f ppf,
1181: hr_soft_coding_keyflex scl
1182: where paf.assignment_id = c_assignment_id
1183: and paf.payroll_id = ppf.payroll_id
1184: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id
1185: and c_effective_end_date between
1242: c_effective_end_date in date) is
1243: select scl.segment1
1244: from per_all_assignments_f paf,
1245: pay_all_payrolls_f ppf,
1246: hr_soft_coding_keyflex scl
1247: where paf.assignment_id = c_assignment_id
1248: and paf.payroll_id = ppf.payroll_id
1249: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id
1250: and c_effective_end_date between
1827: select 1 from dual where exists
1828: (select scl.segment1
1829: from per_all_assignments_f paf,
1830: pay_all_payrolls_f ppf,
1831: hr_soft_coding_keyflex scl
1832: where paf.assignment_id = c_assignment_id
1833: and paf.payroll_id = ppf.payroll_id
1834: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id
1835: and scl.segment1 <> c_tax_ref
2109: select a.assignment_id,
2110: a.effective_end_date
2111: from per_all_assignments_f a,
2112: pay_all_payrolls_f pay,
2113: hr_soft_coding_keyflex flex,
2114: per_periods_of_service serv
2115: where a.person_id = c_person_id
2116: and flex.segment1 = c_tax_ref
2117: and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2161: per_assignment_status_types past,
2162: pay_all_payrolls_f ppf,
2163: per_time_periods ptp,
2164: per_periods_of_service serv,
2165: hr_soft_coding_keyflex flex
2166: WHERE a.person_id BETWEEN stperson AND endperson
2167: AND a.business_group_id +0 = g_business_group_id
2168: AND (g_payroll_id is null
2169: or
2216: per_assignment_status_types past,
2217: pay_all_payrolls_f ppf,
2218: per_time_periods ptp,
2219: per_periods_of_service serv,
2220: hr_soft_coding_keyflex flex
2221: WHERE p.person_id = ppr.person_id
2222: AND ppr.chunk_number = chunk
2223: AND ppr.payroll_action_id = pactid
2224: AND a.business_group_id +0 = g_business_group_id
4033: Cursor csr_get_paye_ref(c_assignment_id NUMBER, c_effective_date DATE) IS
4034: SELECT flex.segment1 paye_ref, paaf.period_of_service_id
4035: FROM per_all_assignments_f paaf,
4036: pay_all_payrolls_f papf,
4037: hr_soft_coding_keyflex flex
4038: WHERE paaf.assignment_id = c_assignment_id
4039: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date
4040: AND paaf.payroll_id = papf.payroll_id
4041: AND c_effective_date BETWEEN papf.effective_start_date and papf.effective_end_date
4121: l_agg_paye_flag per_all_people_f.per_information10%type;
4122: l_found BOOLEAN;
4123: l_dummy NUMBER;
4124:
4125: l_agg_paye_reference hr_soft_coding_keyflex.segment1%type;
4126: l_paye_reference hr_soft_coding_keyflex.segment1%type;
4127: l_period_of_service_id number;
4128: l_agg_period_of_service_id number;
4129: l_action_sequence number;
4122: l_found BOOLEAN;
4123: l_dummy NUMBER;
4124:
4125: l_agg_paye_reference hr_soft_coding_keyflex.segment1%type;
4126: l_paye_reference hr_soft_coding_keyflex.segment1%type;
4127: l_period_of_service_id number;
4128: l_agg_period_of_service_id number;
4129: l_action_sequence number;
4130: