DBA Data[Home] [Help]

APPS.PAY_SS_REP_CATG_METADATA dependencies on PAY_REPORT_DEFINITIONS

Line 88: from pay_report_definitions

84: --
85: DELETE FROM pay_report_variables
86: WHERE business_group_id = p_business_group_id
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

Line 119: FROM pay_report_definitions prd

115: l_legislation_code||' Payslip Template',
116: csr_template_code.template_code,
117: --'DK',
118: p_business_group_id
119: FROM pay_report_definitions prd
120: WHERE report_name = 'Generic Payslip Report (pdf)'
121: AND report_group_id = l_report_group_id
122: AND NOT EXISTS
123: (SELECT NULL