APPS.PAY_AU_RETRO_UPGRADE dependencies on PER_BUSINESS_GROUPS

Line 1748: from per_business_groups

1744: ) ;
1745:
1746: cursor c_legislation_code(cp_business_group_id in number) is
1747: select legislation_code
1748: from per_business_groups
1749: where business_group_id = cp_business_group_id;
1750:
1751: /* Gets all the element sets in which the element is included.*/
1752:

Line 1973: from per_business_groups

1969:
1970:
1971: cursor c_legislation_code(cp_business_group_id in number) is
1972: select legislation_code
1973: from per_business_groups
1974: where business_group_id = cp_business_group_id;
1975:
1976: cursor c_element_set(cp_element_type_id in number
1977: ,cp_classification_id in number

Line 3662: FROM per_business_groups pbg

3658:
3659: /*Bug 5879422 */
3660: CURSOR csr_get_business_group_name IS
3661: SELECT rownum ROW_NUM,pbg.name BUS_GROUP_NAME
3662: FROM per_business_groups pbg
3663: WHERE pbg.legislation_code = g_legislation_code;
3664:
3665: l_leg_rule VARCHAR2(20);
3666:

Line 3737: FROM per_business_groups pbg

3733: AND legislation_code = 'AU';
3734:
3735: CURSOR csr_get_business_group_name IS
3736: SELECT rownum ROW_NUM,pbg.name BG_NAME
3737: FROM per_business_groups pbg
3738: WHERE pbg.legislation_code = g_legislation_code;
3739:
3740: lv_procedure_name VARCHAR2(100);
3741: l_retro_overlap_rule VARCHAR2(1);