APPS.HR_RO_CONTRACT_VAL dependencies on PER_ALL_PEOPLE_F
Line 35: from per_all_people_f ppf
31: and lookup_code = p_ctr_information1;
32:
33: cursor csr_get_securityid is
34: select distinct security_group_id 35: from per_all_people_f ppf 36: ,per_business_groups pbg
37: where ppf.person_id = p_person_id
38: and ppf.business_group_id= pbg.business_group_id
39: and SYSDATE between ppf.effective_start_date and ppf.effective_end_date;