DBA Data[Home] [Help]

APPS.CN_SRP_PAYGROUP_PUB dependencies on CN_ROLE_PAY_GROUPS_ALL

Line 1324: from cn_role_pay_groups_all

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

Line 1560: FROM cn_role_pay_groups_all

1556:
1557: -- begin API
1558: SELECT org_id
1559: INTO l_org_id
1560: FROM cn_role_pay_groups_all
1561: WHERE role_pay_group_id = p_role_pay_group_id;
1562:
1563: -- validate org ID
1564: mo_global.validate_orgid_pub_api

Line 1657: FROM cn_role_pay_groups_all

1653: AND org_id = l_org_id;
1654:
1655: SELECT pay_group_id, start_date, end_date
1656: INTO l_pay_group_id_new, l_pp_start_date_new, l_pp_end_date_new
1657: FROM cn_role_pay_groups_all
1658: WHERE role_pay_group_id = p_role_pay_group_id;
1659:
1660: SELECT name
1661: INTO l_pay_group_name_new