APPS.PAY_ARCH_MISSING_ASG_PKG dependencies on PER_BUSINESS_GROUPS

Line 65: FROM per_business_groups

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

Line 143: FROM per_business_groups

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

Line 373: FROM per_business_groups

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

Line 475: FROM per_business_groups

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