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 1353: from cn_pay_groups_all

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

Line 1629: FROM cn_pay_groups_all

1625:
1626:
1627: SELECT name
1628: INTO l_pay_group_name_old
1629: FROM cn_pay_groups_all
1630: WHERE pay_group_id = l_pay_group_id_old;
1631:
1632: oldrec.employee_type := l_salesrep_type_old;
1633: oldrec.employee_number := l_emp_num_old;

Line 1669: FROM cn_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
1669: FROM cn_pay_groups_all
1670: WHERE pay_group_id = l_pay_group_id_new;
1671:
1672: SELECT count(*)
1673: INTO l_count_srp_pay_group