DBA Data[Home] [Help]

APPS.PER_FNAME_PKG dependencies on PER_BUSINESS_GROUPS

Line 70: from per_all_people_f per, per_business_groups bg

66: cursor csr_get_people_in_leg (p_legislation_code varchar2) is
67: select person_id,
68: effective_start_date,
69: effective_end_date
70: from per_all_people_f per, per_business_groups bg
71: where per.business_group_id = bg.business_group_id
72: and bg.legislation_code = p_legislation_code;
73:
74: -- Fix 3386992 Start

Line 90: from per_all_people_f per, per_business_groups bg

86: suffix,
87: date_of_birth,
88: per.business_group_id,
89: full_name
90: from per_all_people_f per, per_business_groups bg
91: where per.business_group_id = bg.business_group_id
92: and bg.legislation_code = p_legislation_code;
93: -- Fix 3386992 End
94: