DBA Data[Home] [Help]

APPS.PQP_ERT_BUS dependencies on PQP_EXCEPTION_REPORTS

Line 30: , pqp_exception_reports_tl ert

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

Line 31: , pqp_exception_reports exr

27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqp_exception_reports_tl ert
31: , pqp_exception_reports exr
32: where ert.exception_report_id = p_exception_report_id
33: and pbg.business_group_id = exr.business_group_id
34: and exr.exception_report_id = ert.exception_report_id;
35: --

Line 96: ,pqp_exception_reports exr

92: --
93: cursor csr_leg_code is
94: select pbg.legislation_code
95: from per_business_groups pbg
96: ,pqp_exception_reports exr
97: where exr.exception_report_id = p_exception_report_id
98: and pbg.business_group_id = exr.business_group_id;
99:
100: --