APPS.PAY_SS_REP_CATG_METADATA dependencies on PAY_REPORT_CATEGORY_COMPONENTS

Line 91: DELETE FROM pay_report_category_components

87: AND report_definition_id IN ( SELECT report_definition_id
88: from pay_report_definitions
89: where report_name = 'Generic Payslip Report (pdf)' );
90: --
91: DELETE FROM pay_report_category_components
92: WHERE business_group_id = p_business_group_id
93: AND report_category_id IN ( SELECT report_category_id
94: FROM pay_report_categories
95: WHERE short_name = l_legislation_code||'_PAYSLIP_REPORT');

Line 133: INSERT INTO pay_report_category_components

129: END LOOP;
130: --
131: FOR csr_report_varables IN get_report_variables LOOP
132: --
133: INSERT INTO pay_report_category_components
134: (REPORT_CATEGORY_COMP_ID,
135: REPORT_CATEGORY_ID,
136: REPORT_DEFINITION_ID,
137: STYLE_SHEET_VARIABLE_ID,

Line 153: FROM pay_report_category_components

149: AND category_name = l_legislation_code||' Payslip Report'
150: AND report_group_id = l_report_group_id
151: AND NOT EXISTS
152: (SELECT NULL
153: FROM pay_report_category_components
154: WHERE report_category_id = prc.report_category_id
155: AND report_definition_id = csr_report_varables.report_definition_id
156: AND style_sheet_variable_id = csr_report_varables.report_variable_id);
157: --