APPS.PQP_PERASGADD_RIW dependencies on PER_BUSINESS_GROUPS

Line 182: from per_business_groups pbg

178: ,pbg.method_of_generation_emp_num
179: ,pbg.method_of_generation_apl_num
180: ,pbg.method_of_generation_cwk_num
181: ,pbg.business_group_id
182: from per_business_groups pbg
183: where pbg.business_group_id = c_business_group_id;
184:
185: -- Cursor to get the meaning and code for a lookup type
186: cursor csr_chk_code (c_lookup_type in varchar2

Line 8797: from per_business_groups pbg

8793: -- Cursor to get the business group name
8794: --
8795: cursor csr_get_bg_name (c_bg_grp_id in number) is
8796: select pbg.name
8797: from per_business_groups pbg
8798: where pbg.business_group_id = c_bg_grp_id;
8799:
8800: l_bg_name per_business_groups.name%type;
8801: l_proc_name constant varchar2(170):= g_pkg ||'Create_DataPump_BatchHeader';

Line 8800: l_bg_name per_business_groups.name%type;

8796: select pbg.name
8797: from per_business_groups pbg
8798: where pbg.business_group_id = c_bg_grp_id;
8799:
8800: l_bg_name per_business_groups.name%type;
8801: l_proc_name constant varchar2(170):= g_pkg ||'Create_DataPump_BatchHeader';
8802: l_reference varchar2(80);
8803:
8804: begin

Line 11033: per_business_groups_perf pgr

11029: --the values to null so that the api does not throw an error.
11030: Begin
11031: select plr.rule_mode into id_flex_num
11032: from pay_legislation_rules plr,
11033: per_business_groups_perf pgr
11034: where plr.legislation_code = pgr.legislation_code
11035: and pgr.business_group_id = p_business_group_id
11036: and plr.rule_type = 'S'
11037: and exists