APPS.PAY_SS_REP_CATG_METADATA dependencies on PER_BUSINESS_GROUPS

Line 19: FROM per_business_groups

15: AND org_information3 = 'Y';
16: --
17: CURSOR get_legislation_code IS
18: SELECT legislation_code
19: FROM per_business_groups
20: WHERE business_group_id = p_business_group_id;
21: --
22: CURSOR get_report_group_id IS
23: SELECT report_group_id

Line 41: l_legislation_code per_business_groups.legislation_code%TYPE;

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