APPS.PQP_EXR_BUS dependencies on PQP_EXCEPTION_REPORTS

Line 29: , pqp_exception_reports exr

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: --
33: -- Declare local variables

Line 161: ,pqp_exception_reports exr

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: --
165: -- Declare local variables

Line 1381: from pqp_exception_reports

1377:
1378: cursor csr_report_name
1379: is
1380: select 'X'
1381: from pqp_exception_reports
1382: where exception_report_name = p_exception_report_name
1383: and( (legislation_code is not null
1384: and legislation_code = l_legislation_code)
1385: or (business_group_id is not null

Line 1423: -- Check whether a row exists already in pqp_exception_reports

1419: (p_exception_report_name)) or
1420: (NOT l_api_updating)) THEN
1421:
1422: --
1423: -- Check whether a row exists already in pqp_exception_reports
1424: -- with this exception_report_name
1425: --
1426:
1427: hr_utility.set_location(l_proc, 20);