DBA Data[Home] [Help]

APPS.PER_GB_DISABILITY dependencies on PER_BUSINESS_GROUPS

Line 14: ,per_business_groups pbg

10: cursor csr_get_securityid
11: is
12: select distinct security_group_id
13: from per_all_people_f ppf
14: ,per_business_groups pbg
15: where ppf.person_id = p_person_id
16: and ppf.business_group_id= pbg.business_group_id
17: and p_effective_date between
18: ppf.effective_start_date and ppf.effective_end_date;

Line 80: ,per_business_groups pbg

76: is
77: select distinct security_group_id
78: from per_disabilities_f pdf
79: ,per_all_people_f ppf
80: ,per_business_groups pbg
81: where ppf.person_id = pdf.person_id
82: and ppf.business_group_id= pbg.business_group_id
83: and pdf.disability_id = p_disability_id
84: and p_effective_date between