eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PERASGADD_RIW dependencies on PER_BUSINESS_GROUPS

Line 181: from per_business_groups pbg

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

Line 8393: from per_business_groups pbg

8389: -- Cursor to get the business group name
8390: --
8391: cursor csr_get_bg_name (c_bg_grp_id in number) is
8392: select pbg.name
8393: from per_business_groups pbg
8394: where pbg.business_group_id = c_bg_grp_id;
8395:
8396: l_bg_name per_business_groups.name%type;
8397: l_proc_name constant varchar2(170):= g_pkg ||'Create_DataPump_BatchHeader';

Line 8396: l_bg_name per_business_groups.name%type;

8392: select pbg.name
8393: from per_business_groups pbg
8394: where pbg.business_group_id = c_bg_grp_id;
8395:
8396: l_bg_name per_business_groups.name%type;
8397: l_proc_name constant varchar2(170):= g_pkg ||'Create_DataPump_BatchHeader';
8398: l_reference varchar2(80);
8399:
8400: begin

Line 10374: per_business_groups_perf pgr

10370: --the values to null so that the api does not throw an error.
10371: Begin
10372: select plr.rule_mode into id_flex_num
10373: from pay_legislation_rules plr,
10374: per_business_groups_perf pgr
10375: where plr.legislation_code = pgr.legislation_code
10376: and pgr.business_group_id = p_business_group_id
10377: and plr.rule_type = 'S'
10378: and exists