APPS.PAY_SS_REP_CATG_METADATA dependencies on PAY_REPORT_CATEGORIES

Line 30: FROM pay_report_categories

26: AND report_group_name = 'Generic Payslip Report';
27: --
28: CURSOR get_report_category_id(c_leg_code VARCHAR2) IS
29: SELECT report_category_id
30: FROM pay_report_categories
31: WHERE category_name = c_leg_code||' Payslip Report'
32: AND short_name = c_leg_code||'_PAYSLIP_REPORT'
33: AND business_group_id = p_business_group_id;
34: --

Line 42: l_report_category_id pay_report_categories.report_category_id%TYPE;

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;
43: l_report_group_id pay_report_groups.report_group_id%TYPE;
44: --
45: BEGIN
46: --

Line 57: INSERT INTO pay_report_categories

53: CLOSE get_report_category_id;
54: --
55: IF l_report_category_id IS NULL THEN
56: --
57: INSERT INTO pay_report_categories
58: ( REPORT_CATEGORY_ID,
59: REPORT_GROUP_ID,
60: CATEGORY_NAME,
61: --LEGISLATION_CODE,

Line 65: PAY_REPORT_CATEGORIES_S.nextval,

61: --LEGISLATION_CODE,
62: SHORT_NAME,
63: BUSINESS_GROUP_ID)
64: SELECT
65: PAY_REPORT_CATEGORIES_S.nextval,
66: report_group_id,
67: l_legislation_code||' Payslip Report',
68: --'DK',
69: l_legislation_code||'_PAYSLIP_REPORT',

Line 76: FROM pay_report_categories

72: WHERE short_name = 'PAYSLIP_REPORT'
73: AND report_group_name = 'Generic Payslip Report'
74: AND NOT EXISTS
75: (SELECT NULL
76: FROM pay_report_categories
77: WHERE report_group_id = prg.report_group_id
78: AND short_name = l_legislation_code||'_PAYSLIP_REPORT'
79: AND category_name = l_legislation_code||' Payslip Report');
80: --

Line 81: --l_report_category_id := PAY_REPORT_CATEGORIES_S.currval;

77: WHERE report_group_id = prg.report_group_id
78: AND short_name = l_legislation_code||'_PAYSLIP_REPORT'
79: AND category_name = l_legislation_code||' Payslip Report');
80: --
81: --l_report_category_id := PAY_REPORT_CATEGORIES_S.currval;
82: --
83: END IF;
84: --
85: DELETE FROM pay_report_variables

Line 94: FROM pay_report_categories

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');
96: --
97: OPEN get_report_group_id;
98: FETCH get_report_group_id INTO l_report_group_id;

Line 147: FROM pay_report_categories prc

143: csr_report_varables.report_definition_id,
144: csr_report_varables.report_variable_id,
145: --'DK',
146: p_business_group_id
147: FROM pay_report_categories prc
148: WHERE short_name = l_legislation_code||'_PAYSLIP_REPORT'
149: AND category_name = l_legislation_code||' Payslip Report'
150: AND report_group_id = l_report_group_id
151: AND NOT EXISTS