APPS.PAY_SS_REP_CATG_METADATA dependencies on PAY_REPORT_GROUPS

Line 24: FROM pay_report_groups

20: WHERE business_group_id = p_business_group_id;
21: --
22: CURSOR get_report_group_id IS
23: SELECT report_group_id
24: FROM pay_report_groups
25: WHERE short_name = 'PAYSLIP_REPORT'
26: AND report_group_name = 'Generic Payslip Report';
27: --
28: CURSOR get_report_category_id(c_leg_code VARCHAR2) IS

Line 43: l_report_group_id pay_report_groups.report_group_id%TYPE;

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: --
47: OPEN get_legislation_code;

Line 71: FROM pay_report_groups prg

67: l_legislation_code||' Payslip Report',
68: --'DK',
69: l_legislation_code||'_PAYSLIP_REPORT',
70: p_business_group_id
71: FROM pay_report_groups prg
72: WHERE short_name = 'PAYSLIP_REPORT'
73: AND report_group_name = 'Generic Payslip Report'
74: AND NOT EXISTS
75: (SELECT NULL