APPS.PQP_EXR_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: from per_business_groups pbg

24: -- Declare cursor
25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pqp_exception_reports exr
30: where exr.exception_report_id = p_exception_report_id
31: and pbg.business_group_id = exr.business_group_id;
32: --

Line 94: from per_business_groups pbg

90: -- Declare cursor
91: --
92: cursor csr_leg_code is
93: select pbg.legislation_code
94: from per_business_groups pbg
95: where pbg.business_group_id = p_business_group_id;
96: --
97: -- Declare local variables
98: --

Line 160: from per_business_groups pbg

156: --
157: cursor csr_leg_code is
158: select pbg.legislation_code
159: ,exr.legislation_code
160: from per_business_groups pbg
161: ,pqp_exception_reports exr
162: where pbg.business_group_id = exr.business_group_id
163: and exr.exception_report_id= p_exception_report_id;
164: --

Line 471: l_legislation_code per_business_groups.legislation_code%TYPE;

467: --
468: l_proc varchar2(72) := g_package||'chk_balance_type_id';
469: l_api_updating boolean;
470: l_exists varchar2(1);
471: l_legislation_code per_business_groups.legislation_code%TYPE;
472:
473: cursor csr_bal_type
474: is
475: select 'X'

Line 1376: l_legislation_code per_business_groups.legislation_code%TYPE;

1372: --
1373: l_proc varchar2(72) := g_package||'chk_report_name';
1374: l_exists varchar2(1);
1375: l_api_updating boolean;
1376: l_legislation_code per_business_groups.legislation_code%TYPE;
1377:
1378: cursor csr_report_name
1379: is
1380: select 'X'