[Home] [Help]
1315: , org.organization_id
1316: , org.name org_name
1317: from per_all_people_f p
1318: , per_all_assignments_f a
1319: , per_periods_of_service serv
1320: , hr_all_organization_units org
1321: , fnd_sessions sess
1322: where a.assignment_id = p_assignment_id
1323: and sess.session_id = userenv('sessionid')
1326: and a.person_id = p.person_id
1327: and sess.effective_date between
1328: p.effective_start_date and p.effective_end_date
1329: and serv.person_id = p.person_id
1330: and serv.date_start = ( select max(s.date_start) from per_periods_of_service s
1331: where s.person_id = p.person_id
1332: and sess.effective_date >= s.date_start )
1333: and a.organization_id = org.organization_id;
1334:
1877: and pa.date_earned >= c_effective_end_date);
1878: --
1879: cursor csr_last_standard_process (c_period_of_service_id in number) is
1880: select serv.last_standard_process_date
1881: from per_periods_of_service serv
1882: where serv.period_of_service_id = c_period_of_service_id;
1883: --
1884: cursor csr_lsp_payment(c_last_process_date in date,
1885: c_effective_end_date in date,
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
2118: and a.payroll_id = pay.payroll_id
2160: per_all_assignments_f a,
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
2215: per_all_assignments_f a,
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
2854: p.date_of_birth, p.sex
2855: FROM
2856: per_all_people_f p,
2857: hr_all_organization_units org,
2858: per_periods_of_service serv,
2859: per_all_assignments_f ass
2860: WHERE ass.assignment_id = p_assid
2861: AND serv.period_of_service_id = ass.period_of_service_id
2862: AND ass.effective_end_date = p_term_date