DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PER_BUSINESS_GROUPS

Line 1539: from per_business_groups

1535: ) ;
1536:
1537: cursor c_legislation_code(cp_business_group_id in number) is
1538: select legislation_code
1539: from per_business_groups
1540: where business_group_id = cp_business_group_id;
1541:
1542: /* Gets all the element sets in which the element is included.*/
1543:

Line 1770: from per_business_groups

1766:
1767:
1768: cursor c_legislation_code(cp_business_group_id in number) is
1769: select legislation_code
1770: from per_business_groups
1771: where business_group_id = cp_business_group_id;
1772:
1773: cursor c_element_set(cp_element_type_id in number
1774: ,cp_classification_id in number

Line 3223: FROM per_business_groups pbg

3219:
3220: /*Bug 5879422 */
3221: CURSOR csr_get_business_group_name IS
3222: SELECT rownum ROW_NUM,pbg.name BUS_GROUP_NAME
3223: FROM per_business_groups pbg
3224: WHERE pbg.legislation_code = g_legislation_code;
3225:
3226: l_leg_rule VARCHAR2(20);
3227: