APPS.PAY_P45_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 792: per_assignment_status_types past

788: -- 5144323: Ensure the action belongs to an assignment that shares continuous active
789: -- period of employement with the given terminated assignment
790: AND a.effective_start_date = (SELECT /*+ ORDERED use_nl(past a2) */ max(a2.effective_start_date)
791: FROM per_all_assignments_f a2,
792: per_assignment_status_types past
793: WHERE a2.assignment_id = a.assignment_id
794: AND a2.effective_start_date <= c_agg_active_end
795: AND a2.effective_end_date >= c_agg_active_start
796: AND a2.assignment_status_type_id = past.assignment_status_type_id

Line 1793: per_assignment_status_types past

1789: c_effective_end_date in date) is
1790: select 1 from dual where exists
1791: (select paf.effective_end_date
1792: from per_all_assignments_f paf,
1793: per_assignment_status_types past
1794: where past.assignment_status_type_id = paf.assignment_status_type_id
1795: and paf.assignment_id = c_assignment_id
1796: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
1797: and paf.effective_end_date > c_effective_end_date);

Line 2128: per_assignment_status_types past

2124: -- 5144323: only last active/suspended dt instances of the
2125: -- assignemnts are needed
2126: AND a.effective_end_date = ( SELECT max(effective_end_date)
2127: FROM per_all_assignments_f a1,
2128: per_assignment_status_types past
2129: WHERE a.assignment_id = a1.assignment_id
2130: AND a1.assignment_status_type_id = past.assignment_status_type_id
2131: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN'))
2132: -- 5144323: assignments must exist during the aggregation period

Line 2141: per_assignment_status_types past

2137: -- 5144323: assignments must share continuous period of
2138: -- employment with the input assignment
2139: AND EXISTS (SELECT 1
2140: FROM per_all_assignments_f a3,
2141: per_assignment_status_types past
2142: WHERE a.assignment_id = a3.assignment_id
2143: AND a3.assignment_status_type_id = past.assignment_status_type_id
2144: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
2145: AND a3.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_term_date)

Line 2161: per_assignment_status_types past,

2157: max(a.effective_end_date) asg_end_date,
2158: ptp.regular_payment_date
2159: FROM per_all_people_f p,
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

Line 2184: -- per_assignment_status_types past

2180:
2181: -- AND a.effective_end_date = -- the latest active or susp asg exclude DT update
2182: -- (select max(asg2.effective_end_date)
2183: -- from per_all_assignments_f asg2,
2184: -- per_assignment_status_types past
2185: -- where asg2.assignment_id = a.assignment_id
2186: -- and asg2.assignment_status_type_id =past.assignment_status_type_id
2187: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2188: -- and asg2.effective_end_date <> hr_general.end_of_time)

Line 2216: per_assignment_status_types past,

2212: ptp.regular_payment_date
2213: FROM pay_population_ranges ppr,
2214: per_all_people_f p,
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

Line 2242: -- per_assignment_status_types past

2238:
2239: --AND a.effective_end_date = -- the latest active or susp asg exclude DT update
2240: -- (select max(asg2.effective_end_date)
2241: -- from per_all_assignments_f asg2,
2242: -- per_assignment_status_types past
2243: -- where asg2.assignment_id = a.assignment_id
2244: -- and asg2.assignment_status_type_id =
2245: -- past.assignment_status_type_id
2246: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')

Line 4051: per_assignment_status_types past

4047: c_effective_date date
4048: ) is
4049: select 1
4050: from per_all_assignments_f a,
4051: per_assignment_status_types past
4052: where a.assignment_status_type_id = past.assignment_status_type_id
4053: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
4054: and a.assignment_id = c_assignment_id
4055: and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_agg_assignment_id, c_tax_ref, c_effective_date)

Line 4072: per_assignment_status_types past

4068: --
4069: cursor csr_asg_last_active_date(c_assignment_id number) is
4070: select max(effective_end_date)
4071: from per_all_assignments_f a,
4072: per_assignment_status_types past
4073: where a.assignment_id = c_assignment_id
4074: and a.assignment_status_type_id = past.assignment_status_type_id
4075: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
4076: