APPS.PQP_EXCP_RPT dependencies on PQP_EXCEPTION_REPORT_GROUPS

Line 196: p_group_id pqp_exception_report_groups.exception_group_id%TYPE

192: --
193: -- Cursor to get the exception report group name
194: --
195: CURSOR c_get_exception_group_name(
196: p_group_id pqp_exception_report_groups.exception_group_id%TYPE
197: )
198: IS
199: SELECT EXCEPTION_GROUP_NAME
200: FROM pqp_exception_report_groups

Line 200: FROM pqp_exception_report_groups

196: p_group_id pqp_exception_report_groups.exception_group_id%TYPE
197: )
198: IS
199: SELECT EXCEPTION_GROUP_NAME
200: FROM pqp_exception_report_groups
201: WHERE EXCEPTION_GROUP_ID = p_group_id;
202: -- End of cursor
203:
204: --

Line 233: FROM pqp_exception_report_groups

229: AND (business_group_id= p_business_group_id
230: OR business_group_id IS NULL)
231: UNION
232: SELECT DISTINCT output_format
233: FROM pqp_exception_report_groups
234: WHERE exception_group_name = p_group_name
235: AND (business_group_id= p_business_group_id
236: OR business_group_id IS NULL);
237: -- End of cursor

Line 263: l_exception_group_name pqp_exception_report_groups.exception_group_name%TYPE;

259: l_currency_format varchar2(40);
260: l_variance_value pqp_exception_reports.variance_value%TYPE;
261: l_comparison_value pqp_exception_reports.comparison_value%TYPE;
262: l_exception_report_name pqp_exception_reports.exception_report_name%TYPE;
263: l_exception_group_name pqp_exception_report_groups.exception_group_name%TYPE;
264: l_output_format pqp_exception_reports.output_format%TYPE;
265: l_comparison_type varchar2(80);
266: l_variance_type pqp_exception_reports.variance_type%TYPE;
267: l_variance_operator varchar2(80);