APPS.CN_PAYGROUP_PVT dependencies on CN_ROLE_PAY_GROUPS

Line 944: FROM cn_role_pay_groups

940: END IF;
941:
942: SELECT COUNT(1)
943: INTO l_count
944: FROM cn_role_pay_groups
945: WHERE pay_group_id = l_pay_group_id;
946:
947:
948: IF l_count <> 0

Line 957: FROM cn_role_pay_groups

953: CLOSE get_pay_group;
954:
955: SELECT MIN(start_date)
956: INTO l_start_date
957: FROM cn_role_pay_groups
958: WHERE pay_group_id = l_pay_group_id;
959:
960: SELECT MAX(end_date)
961: INTO l_end_date

Line 962: FROM cn_role_pay_groups

958: WHERE pay_group_id = l_pay_group_id;
959:
960: SELECT MAX(end_date)
961: INTO l_end_date
962: FROM cn_role_pay_groups
963: WHERE pay_group_id = l_pay_group_id;
964:
965:
966: IF l_start_date < p_paygroup_rec.start_date

Line 1426: FROM cn_role_pay_groups

1422:
1423: END IF;
1424: SELECT COUNT(1)
1425: INTO l_count_role
1426: FROM cn_role_pay_groups
1427: WHERE pay_group_id = l_pay_group_id;
1428:
1429: IF l_count_role <> 0
1430: THEN