APPS.PAY_P45_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1433: , per_periods_of_service serv

1429: , p.date_of_birth /* P45 A4 2008/09 */
1430: , p.sex /* P45 A4 2008/09 */
1431: from per_all_people_f p
1432: , per_all_assignments_f a
1433: , per_periods_of_service serv
1434: , hr_all_organization_units org
1435: , fnd_sessions sess
1436: where a.assignment_id = p_assignment_id
1437: and sess.session_id = userenv('sessionid')

Line 1444: and serv.date_start = ( select max(s.date_start) from per_periods_of_service s

1440: and a.person_id = p.person_id
1441: and sess.effective_date between
1442: p.effective_start_date and p.effective_end_date
1443: and serv.person_id = p.person_id
1444: and serv.date_start = ( select max(s.date_start) from per_periods_of_service s
1445: where s.person_id = p.person_id
1446: and sess.effective_date >= s.date_start )
1447: and a.organization_id = org.organization_id;
1448:

Line 2003: from per_periods_of_service serv

1999: and pa.date_earned >= c_effective_end_date);
2000: --
2001: cursor csr_last_standard_process (c_period_of_service_id in number) is
2002: select serv.last_standard_process_date
2003: from per_periods_of_service serv
2004: where serv.period_of_service_id = c_period_of_service_id;
2005: --
2006: cursor csr_lsp_payment(c_last_process_date in date,
2007: c_effective_end_date in date,

Line 2241: per_periods_of_service serv

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
2245: and a.payroll_id = pay.payroll_id

Line 2291: per_periods_of_service serv,

2287: per_all_assignments_f a,
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

Line 2350: per_periods_of_service serv,

2346: per_all_assignments_f a,
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

Line 3224: per_periods_of_service serv,

3220: p.date_of_birth, p.sex
3221: FROM
3222: per_all_people_f p,
3223: hr_all_organization_units org,
3224: per_periods_of_service serv,
3225: per_all_assignments_f ass
3226: WHERE ass.assignment_id = p_assid
3227: AND serv.period_of_service_id = ass.period_of_service_id
3228: AND ass.effective_end_date = p_term_date