APPS.CN_SRP_PAYGROUP_PUB dependencies on CN_PAY_GROUPS_ALL

Line 228: FROM cn_pay_groups_all

224: l_create_rec cn_srp_paygroup_pvt.paygroup_assign_rec;
225:
226: CURSOR get_pay_group_id_cur IS
227: SELECT pay_group_id
228: FROM cn_pay_groups_all
229: WHERE name = p_paygroup_assign_rec.pay_group_name
230: AND org_id = l_org_id;
231: l_get_pay_group_id_rec get_pay_group_id_cur%ROWTYPE;
232:

Line 690: FROM cn_pay_groups_all

686: l_bind_data_id NUMBER;
687:
688: CURSOR get_pay_group_id_cur(p_name VARCHAR2, p_org_id NUMBER) IS
689: SELECT pay_group_id
690: FROM cn_pay_groups_all
691: WHERE name = p_name
692: AND org_id = p_org_id;
693: l_old_pay_group_id cn_pay_groups.pay_group_id%TYPE;
694:

Line 1352: from cn_pay_groups_all

1348: AND org_id = l_org_id;
1349:
1350: select name
1351: into l_pay_group_name
1352: from cn_pay_groups_all
1353: where pay_group_id = l_pay_group_id;
1354:
1355: l_start_date := NULL;
1356: l_end_date := NULL;

Line 1623: FROM cn_pay_groups_all

1619: AND org_id = l_org_id;
1620:
1621: SELECT name
1622: INTO l_pay_group_name_old
1623: FROM cn_pay_groups_all
1624: WHERE pay_group_id = l_pay_group_id_old;
1625:
1626: oldrec.employee_type := l_salesrep_type_old;
1627: oldrec.employee_number := l_emp_num_old;

Line 1662: FROM cn_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
1662: FROM cn_pay_groups_all
1663: WHERE pay_group_id = l_pay_group_id_new;
1664:
1665: SELECT count(*)
1666: INTO l_count_srp_pay_group