DBA Data[Home] [Help]

APPS.HR_RO_CONTRACT_VAL dependencies on PER_BUSINESS_GROUPS

Line 36: ,per_business_groups pbg

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;
40: