APPS.PYUDET dependencies on STANDARD

Line 184: pps.last_standard_process_date,

180: nvl(peo.per_information10,'N') agg_flag,
181: nvl(peo.per_information2, 'N') dir_flag,
182: ppt.system_person_type,
183: pps.actual_termination_date,
184: pps.last_standard_process_date,
185: g_effective_date,
186: peo.effective_start_date,
187: peo.effective_end_date
188: from per_all_people_f peo,

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

205: pps.final_process_date > g_effective_date)
206: or
207: (pps.final_process_date is null))
208: group by peo.full_name, peo.national_identifier, peo.per_information10, peo.per_information2,
209: ppt.system_person_type, pps.actual_termination_date, pps.last_standard_process_date,
210: g_effective_date, peo.effective_start_date, peo.effective_end_date
211: -- Bug 6957644 modified p_id to upper(peo.full_name) to report order by name
212: --Bug 6741064 modified p_id to upper(peo.full_name) to report order by name
213: order by upper(peo.full_name), decode(system_person_type,'EMP',1,'EMP_APL',2,3);

Line 1820: pps.last_standard_process_date,

1816: peo.national_identifier,
1817: nvl(peo.per_information10,'N') agg_flag,
1818: 'EMP', --ppt.system_person_type,
1819: pps.actual_termination_date,
1820: pps.last_standard_process_date,
1821: p_m34_rec.effective_date
1822: from per_all_people_f peo,
1823: per_all_assignments_f asg,
1824: per_periods_of_service pps

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

1845: and ptu.person_type_id = ppt.person_type_id
1846: and ppt.system_person_type in ('EMP','EMP_APL')
1847: and p_m34_rec.effective_date between ptu.effective_start_date and ptu.effective_end_date)
1848: group by peo.last_name, peo.full_name, peo.national_identifier, peo.per_information10,
1849: 'EMP' /*ppt.system_person_type*/, pps.actual_termination_date, pps.last_standard_process_date
1850: order by p_id;
1851:
1852: cursor csr_count_emp(p_tax_district varchar2,
1853: p_person_id number,

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

1924: l_person_rec.ni_number := r_person_rec.national_identifier;
1925: l_person_rec.aggregate_flag := r_person_rec.agg_flag;
1926: l_person_rec.person_type := 'EMP';
1927: l_person_rec.term_date := r_person_rec.actual_termination_date;
1928: l_person_rec.lsp_date := r_person_rec.last_standard_process_date;
1929: end if;
1930: end loop;
1931: if l_counter = 0 then
1932: raise no_data_found;