APPS.PER_PEOPLE_V14_PKG dependencies on PER_BUSINESS_GROUPS

Line 57: FROM per_business_groups pbg

53: SELECT pbg.legislation_code
54: , pbg.name
55: , DECODE(pbg.METHOD_OF_GENERATION_EMP_NUM,'A'
56: , X_property_off , X_property_on)
57: FROM per_business_groups pbg
58: WHERE pbg.business_group_id = X_Business_group_id;
59: --
60: CURSOR expense_address
61: IS

Line 169: (select distinct business_group_id from per_business_groups

165: -- Bug 14584982
166:
167: l_sql_text:= 'select fspa.set_of_books_id,fspa.expense_check_address_flag
168: from FINANCIALS_SYSTEM_PARAMS_ALL fspa where fspa.business_group_id =
169: (select distinct business_group_id from per_business_groups
170: where name = '||''''||X_business_group_name||''''||
171: ' and legislation_code = '||''''||X_Legislation_Code||''''||')';
172: -- Bug 14584982
173: