APPS.PAY_SS_REP_CATG_METADATA dependencies on PAY_REPORT_VARIABLES

Line 38: FROM pay_report_variables

34: --
35: CURSOR get_report_variables IS
36: SELECT report_variable_id
37: ,report_definition_id
38: FROM pay_report_variables
39: WHERE business_group_id = p_business_group_id;
40: --
41: l_legislation_code per_business_groups.legislation_code%TYPE;
42: l_report_category_id pay_report_categories.report_category_id%TYPE;

Line 85: DELETE FROM pay_report_variables

81: --l_report_category_id := PAY_REPORT_CATEGORIES_S.currval;
82: --
83: END IF;
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)' );

Line 103: INSERT INTO pay_report_variables

99: CLOSE get_report_group_id;
100: --
101: FOR csr_template_code IN get_template_code LOOP
102: --
103: INSERT INTO pay_report_variables
104: ( REPORT_VARIABLE_ID,
105: REPORT_DEFINITION_ID,
106: DEFINITION_TYPE,
107: NAME,

Line 112: PAY_REPORT_VARIABLES_S.nextval,

108: VALUE,
109: --LEGISLATION_CODE,
110: BUSINESS_GROUP_ID)
111: SELECT
112: PAY_REPORT_VARIABLES_S.nextval,
113: report_definition_id,
114: 'SS',
115: l_legislation_code||' Payslip Template',
116: csr_template_code.template_code,

Line 124: FROM pay_report_variables

120: WHERE report_name = 'Generic Payslip Report (pdf)'
121: AND report_group_id = l_report_group_id
122: AND NOT EXISTS
123: (SELECT NULL
124: FROM pay_report_variables
125: WHERE value = csr_template_code.template_code
126: AND name = l_legislation_code||' Payslip Template'
127: AND report_definition_id = prd.report_definition_id);
128: --