DBA Data[Home] [Help]

APPS.CN_SRP_PAYGROUP_PUB dependencies on CN_ROLE_PAY_GROUPS_ALL

Line 1325: from cn_role_pay_groups_all

1321:
1322: -- begin API
1323: select pay_group_id, start_date, end_date, org_id
1324: into l_pay_group_id, l_pg_start_date, l_pg_end_date, l_org_id
1325: from cn_role_pay_groups_all
1326: where role_pay_group_id = p_role_pay_group_id;
1327:
1328: -- validate org ID
1329: mo_global.validate_orgid_pub_api

Line 1564: FROM cn_role_pay_groups_all

1560:
1561: -- begin API
1562: SELECT org_id
1563: INTO l_org_id
1564: FROM cn_role_pay_groups_all
1565: WHERE role_pay_group_id = p_role_pay_group_id;
1566:
1567: -- validate org ID
1568: mo_global.validate_orgid_pub_api

Line 1664: FROM cn_role_pay_groups_all

1660: AND org_id = l_org_id;
1661:
1662: SELECT pay_group_id, start_date, end_date
1663: INTO l_pay_group_id_new, l_pp_start_date_new, l_pp_end_date_new
1664: FROM cn_role_pay_groups_all
1665: WHERE role_pay_group_id = p_role_pay_group_id;
1666:
1667: SELECT name
1668: INTO l_pay_group_name_new