eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_P45_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 839: per_assignment_status_types past

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
841: AND */ a2.effective_start_date <= c_agg_active_end
842: AND a2.effective_end_date >= c_agg_active_start
843: AND a2.assignment_status_type_id = past.assignment_status_type_id

Line 870: -- per_assignment_status_types past

866: -- 5144323: Ensure the action belongs to an assignment that shares continuous active
867: -- period of employement with the given terminated assignment
868: -- AND a.effective_start_date = (SELECT /*+ ORDERED */ max(a2.effective_start_date)
869: -- FROM per_all_assignments_f a2,
870: -- per_assignment_status_types past
871: -- WHERE a2.assignment_id = a.assignment_id
872: -- AND a2.effective_start_date <= to_date(c_agg_active_end, 'MM/DD/YYYY HH24:MI:SS')
873: -- AND a2.effective_end_date >= to_date(c_agg_active_start, 'MM/DD/YYYY HH24:MI:SS')
874: -- AND a2.assignment_status_type_id = past.assignment_status_type_id

Line 1910: per_assignment_status_types past

1906: c_effective_end_date in date) is
1907: select 1 from dual where exists
1908: (select paf.effective_end_date
1909: from per_all_assignments_f paf,
1910: per_assignment_status_types past
1911: where past.assignment_status_type_id = paf.assignment_status_type_id
1912: and paf.assignment_id = c_assignment_id
1913: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
1914: and paf.effective_end_date > c_effective_end_date);

Line 2255: per_assignment_status_types past

2251: -- 5144323: only last active/suspended dt instances of the
2252: -- assignemnts are needed
2253: AND a.effective_end_date = ( SELECT max(effective_end_date)
2254: FROM per_all_assignments_f a1,
2255: per_assignment_status_types past
2256: WHERE a.assignment_id = a1.assignment_id
2257: AND a1.assignment_status_type_id = past.assignment_status_type_id
2258: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN'))
2259: -- 5144323: assignments must exist during the aggregation period

Line 2268: per_assignment_status_types past

2264: -- 5144323: assignments must share continuous period of
2265: -- employment with the input assignment
2266: AND EXISTS (SELECT 1
2267: FROM per_all_assignments_f a3,
2268: per_assignment_status_types past
2269: WHERE a.assignment_id = a3.assignment_id
2270: AND a3.assignment_status_type_id = past.assignment_status_type_id
2271: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
2272: AND a3.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_term_date)

Line 2288: per_assignment_status_types past,

2284: max(a.effective_end_date) asg_end_date,
2285: ptp.regular_payment_date
2286: FROM per_all_people_f p,
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

Line 2312: -- per_assignment_status_types past

2308:
2309: -- AND a.effective_end_date = -- the latest active or susp asg exclude DT update
2310: -- (select max(asg2.effective_end_date)
2311: -- from per_all_assignments_f asg2,
2312: -- per_assignment_status_types past
2313: -- where asg2.assignment_id = a.assignment_id
2314: -- and asg2.assignment_status_type_id =past.assignment_status_type_id
2315: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2316: -- and asg2.effective_end_date <> hr_general.end_of_time)

Line 2347: per_assignment_status_types past,

2343: ptp.regular_payment_date
2344: FROM pay_population_ranges ppr,
2345: per_all_people_f p,
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

Line 2374: -- per_assignment_status_types past

2370:
2371: --AND a.effective_end_date = -- the latest active or susp asg exclude DT update
2372: -- (select max(asg2.effective_end_date)
2373: -- from per_all_assignments_f asg2,
2374: -- per_assignment_status_types past
2375: -- where asg2.assignment_id = a.assignment_id
2376: -- and asg2.assignment_status_type_id =
2377: -- past.assignment_status_type_id
2378: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')

Line 4858: per_assignment_status_types past

4854: c_effective_date date
4855: ) is
4856: select 1
4857: from per_all_assignments_f a,
4858: per_assignment_status_types past
4859: where a.assignment_status_type_id = past.assignment_status_type_id
4860: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
4861: and a.assignment_id = c_assignment_id
4862: and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_agg_assignment_id, c_tax_ref, c_effective_date)

Line 4879: per_assignment_status_types past

4875: --
4876: cursor csr_asg_last_active_date(c_assignment_id number) is
4877: select max(effective_end_date)
4878: from per_all_assignments_f a,
4879: per_assignment_status_types past
4880: where a.assignment_id = c_assignment_id
4881: and a.assignment_status_type_id = past.assignment_status_type_id
4882: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
4883: