APPS.PYUDET dependencies on STANDARD

Line 250: pps.last_standard_process_date,

246: nvl(peo.per_information10,'N') agg_flag,
247: nvl(peo.per_information2, 'N') dir_flag,
248: ppt.system_person_type,
249: pps.actual_termination_date,
250: pps.last_standard_process_date,
251: g_effective_date,
252: peo.effective_start_date,
253: peo.effective_end_date,
254: scl.segment1 -- Bug#8497477

Line 284: ppt.system_person_type, pps.actual_termination_date, pps.last_standard_process_date,

280: or
281: (pps.final_process_date is null))
282: -- Bug#8497477: changed group by tax reference followed by existing group by.
283: group by scl.segment1,peo.person_id, peo.full_name, peo.national_identifier, peo.per_information10, peo.per_information2,
284: ppt.system_person_type, pps.actual_termination_date, pps.last_standard_process_date,
285: g_effective_date, peo.effective_start_date, peo.effective_end_date
286: -- Bug 6957644 modified p_id to upper(peo.full_name) to report order by name
287: --Bug 6741064 modified p_id to upper(peo.full_name) to report order by name
288: -- Bug#8497477: changed order by tax reference followed by existing oreder by.

Line 2024: pps.last_standard_process_date,

2020: peo.national_identifier,
2021: nvl(peo.per_information10,'N') agg_flag,
2022: 'EMP', --ppt.system_person_type,
2023: pps.actual_termination_date,
2024: pps.last_standard_process_date,
2025: p_m34_rec.effective_date
2026: from per_all_people_f peo,
2027: per_all_assignments_f asg,
2028: per_periods_of_service pps

Line 2055: , pps.actual_termination_date, pps.last_standard_process_date

2051: and p_m34_rec.effective_date between ptu.effective_start_date and ptu.effective_end_date)
2052: group by peo.last_name, peo.full_name, peo.national_identifier, peo.per_information10,
2053: 'EMP'
2054: --ppt.system_person_type
2055: , pps.actual_termination_date, pps.last_standard_process_date
2056: order by p_id;*/
2057:
2058: cursor csr_fetch_asg_asgno is
2059: select max(peo.person_id) p_id,

Line 2066: pps.last_standard_process_date,

2062: peo.national_identifier,
2063: nvl(peo.per_information10,'N') agg_flag,
2064: 'EMP', --ppt.system_person_type,
2065: pps.actual_termination_date,
2066: pps.last_standard_process_date,
2067: p_m34_rec.effective_date
2068: from per_all_people_f peo,
2069: per_all_assignments_f asg,
2070: per_periods_of_service pps

Line 2093: 'EMP' /*ppt.system_person_type*/, pps.actual_termination_date, pps.last_standard_process_date

2089: and ptu.person_type_id = ppt.person_type_id
2090: and ppt.system_person_type in ('EMP','EMP_APL')
2091: and p_m34_rec.effective_date between ptu.effective_start_date and ptu.effective_end_date)
2092: group by peo.last_name, peo.full_name, peo.national_identifier, peo.per_information10,
2093: 'EMP' /*ppt.system_person_type*/, pps.actual_termination_date, pps.last_standard_process_date
2094: order by p_id;
2095:
2096: cursor csr_fetch_asg_natid is
2097: select max(peo.person_id) p_id,

Line 2104: pps.last_standard_process_date,

2100: peo.national_identifier,
2101: nvl(peo.per_information10,'N') agg_flag,
2102: 'EMP', --ppt.system_person_type,
2103: pps.actual_termination_date,
2104: pps.last_standard_process_date,
2105: p_m34_rec.effective_date
2106: from per_all_people_f peo,
2107: per_all_assignments_f asg,
2108: per_periods_of_service pps

Line 2131: 'EMP' /*ppt.system_person_type*/, pps.actual_termination_date, pps.last_standard_process_date

2127: and ptu.person_type_id = ppt.person_type_id
2128: and ppt.system_person_type in ('EMP','EMP_APL')
2129: and p_m34_rec.effective_date between ptu.effective_start_date and ptu.effective_end_date)
2130: group by peo.last_name, peo.full_name, peo.national_identifier, peo.per_information10,
2131: 'EMP' /*ppt.system_person_type*/, pps.actual_termination_date, pps.last_standard_process_date
2132: order by p_id;
2133:
2134: cursor csr_fetch_asg_other is
2135: select max(peo.person_id) p_id,

Line 2142: pps.last_standard_process_date,

2138: peo.national_identifier,
2139: nvl(peo.per_information10,'N') agg_flag,
2140: 'EMP', --ppt.system_person_type,
2141: pps.actual_termination_date,
2142: pps.last_standard_process_date,
2143: p_m34_rec.effective_date
2144: from per_all_people_f peo,
2145: per_all_assignments_f asg,
2146: per_periods_of_service pps

Line 2169: 'EMP' /*ppt.system_person_type*/, pps.actual_termination_date, pps.last_standard_process_date

2165: and ptu.person_type_id = ppt.person_type_id
2166: and ppt.system_person_type in ('EMP','EMP_APL')
2167: and p_m34_rec.effective_date between ptu.effective_start_date and ptu.effective_end_date)
2168: group by peo.last_name, peo.full_name, peo.national_identifier, peo.per_information10,
2169: 'EMP' /*ppt.system_person_type*/, pps.actual_termination_date, pps.last_standard_process_date
2170: order by p_id;
2171: --For Bug 7649174 End
2172: cursor csr_count_emp(p_tax_district varchar2,
2173: p_person_id number,

Line 2250: l_person_rec.lsp_date := r_person_rec.last_standard_process_date;

2246: l_person_rec.ni_number := r_person_rec.national_identifier;
2247: l_person_rec.aggregate_flag := r_person_rec.agg_flag;
2248: l_person_rec.person_type := 'EMP';
2249: l_person_rec.term_date := r_person_rec.actual_termination_date;
2250: l_person_rec.lsp_date := r_person_rec.last_standard_process_date;
2251: end if;
2252: end loop; */
2253: if (p_m34_rec.assignment_number is not null and p_m34_rec.national_identifier is null) then
2254: open csr_fetch_asg_asgno;

Line 2284: l_person_rec.lsp_date := r_person_rec.last_standard_process_date;

2280: l_person_rec.ni_number := r_person_rec.national_identifier;
2281: l_person_rec.aggregate_flag := r_person_rec.agg_flag;
2282: l_person_rec.person_type := 'EMP';
2283: l_person_rec.term_date := r_person_rec.actual_termination_date;
2284: l_person_rec.lsp_date := r_person_rec.last_standard_process_date;
2285: end if;
2286: end loop;
2287: --For Bug 7649174 Start
2288: if (p_m34_rec.assignment_number is not null and p_m34_rec.national_identifier is null) then