APPS.HR_CONTRACT_API dependencies on PER_ALL_PEOPLE_F

Line 93: from per_all_people_f per

89: l_business_group_id per_contracts_f.business_group_id%TYPE;
90: --
91: cursor csr_get_derived_details is
92: select per.business_group_id
93: from per_all_people_f per
94: where per.person_id = p_person_id
95: and p_effective_date between per.effective_start_date
96: and per.effective_end_date;
97: begin

Line 518: from per_all_people_f per

514: l_temp_ovn number := p_object_version_number;
515: --
516: cursor csr_get_derived_details is
517: select per.business_group_id
518: from per_all_people_f per
519: where per.person_id = p_person_id
520: and p_effective_date between per.effective_start_date
521: and per.effective_end_date;
522: --

Line 1076: and not exists(select 1 from per_all_people_f

1072: cursor csr_ctr_orphaned (p_person_id in number) is
1073: select contract_id, effective_start_date, object_version_number
1074: from per_contracts_f
1075: where person_id = p_person_id
1076: and not exists(select 1 from per_all_people_f
1077: where person_id = p_person_id);
1078: --
1079: l_contract_id per_contracts_f.contract_id%TYPE;
1080: l_assignment_id per_all_assignments_f.assignment_id%TYPE;