APPS.PAY_ARCH_MISSING_ASG_PKG dependencies on PER_BUSINESS_GROUPS

Line 62: FROM per_business_groups

58: -- Get legislation code
59: CURSOR c_get_leg_code(cp_business_group_id NUMBER
60: ) IS
61: SELECT legislation_code
62: FROM per_business_groups
63: WHERE business_group_id = cp_business_group_id;
64: --
65: lv_legislative_param VARCHAR2(240);
66: lv_legislation_code VARCHAR2(2);

Line 140: FROM per_business_groups

136: -- Get legislation code
137: CURSOR c_get_leg_code(cp_business_group_id NUMBER
138: ) IS
139: SELECT legislation_code
140: FROM per_business_groups
141: WHERE business_group_id = cp_business_group_id;
142:
143: -- Get report_format
144: CURSOR c_get_report_format(cp_report_type VARCHAR2,

Line 370: FROM per_business_groups

366: -- Get legislation code
367: CURSOR c_get_leg_code(cp_business_group_id NUMBER
368: ) IS
369: SELECT legislation_code
370: FROM per_business_groups
371: WHERE business_group_id = cp_business_group_id;
372:
373: -- Get Balance Attribute ID
374: CURSOR c_get_bal_attribute_id(cp_attribute_name varchar2) IS

Line 472: FROM per_business_groups

468: -- Get legislation code
469: CURSOR c_get_leg_code(cp_business_group_id NUMBER
470: ) IS
471: SELECT legislation_code
472: FROM per_business_groups
473: WHERE business_group_id = cp_business_group_id;
474:
475: lv_result_value number:=0;
476: lv_count number;