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.PYUDET dependencies on PER_ALL_PEOPLE_F

Line 255: from per_all_people_f peo,

251: g_effective_date,
252: peo.effective_start_date,
253: peo.effective_end_date,
254: scl.segment1 -- Bug#8497477
255: from per_all_people_f peo,
256: per_all_assignments_f asg,
257: per_periods_of_service pps,
258: per_person_type_usages_f ptu,
259: per_person_types ppt,

Line 2026: from per_all_people_f peo,

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
2029: where asg.business_group_id = g_business_group_id
2030: and peo.business_group_id = g_business_group_id

Line 2068: from per_all_people_f peo,

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
2071: where asg.business_group_id = g_business_group_id
2072: and peo.business_group_id = g_business_group_id

Line 2106: from per_all_people_f peo,

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
2109: where asg.business_group_id = g_business_group_id
2110: and peo.business_group_id = g_business_group_id

Line 2144: from per_all_people_f peo,

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
2147: where asg.business_group_id = g_business_group_id
2148: and peo.business_group_id = g_business_group_id

Line 2194: from per_all_people_f peo,

2190: cursor csr_check_future_asg(p_tax_district varchar2,
2191: p_person_id number,
2192: p_date date) is
2193: select count(*)
2194: from per_all_people_f peo,
2195: per_all_assignments_f asg,
2196: pay_all_payrolls_f pay,
2197: hr_soft_coding_keyflex sck
2198: where peo.person_id = p_person_id

Line 2519: per_all_people_f papf

2515: nvl(papf.per_information10,'N')
2516: from per_assignment_extra_info paei,
2517: per_all_assignments_f paaf,
2518: per_assignment_status_types pat,
2519: per_all_people_f papf
2520: where paei.AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION'
2521: and paei.AEI_INFORMATION3 = p_m34_rec.assignment_number
2522: and paaf.assignment_id = paei.assignment_id
2523: and paaf.assignment_status_type_id = pat.assignment_status_type_id

Line 2989: l_person_id per_all_people_f.person_id%type;

2985: p_validate_only in VARCHAR2 DEFAULT 'GB_VALIDATE_COMMIT')
2986: IS
2987: l_m34_rec g_tax_code_interface;
2988: l_m12_rec g_typ_per_record;
2989: l_person_id per_all_people_f.person_id%type;
2990: l_process boolean;
2991: BEGIN
2992: --hr_utility.trace_on(null,'hello');
2993: hr_utility.trace('Start of PYUDET');