DBA Data[Home] [Help]

APPS.CN_PAYRUN_PVT dependencies on CN_PAY_GROUPS

Line 1137: FROM cn_pay_groups

1133: l_api_name CONSTANT VARCHAR2(30) := 'Validate_pay_group';
1134:
1135: CURSOR get_count IS
1136: SELECT COUNT(1)
1137: FROM cn_pay_groups
1138: WHERE pay_group_id = p_pay_group_id;
1139:
1140: l_count NUMBER;
1141:

Line 1209: FROM cn_pay_groups cnpg,

1205: l_api_name CONSTANT VARCHAR2(30) := 'Validate_pay_period';
1206:
1207: CURSOR get_count IS
1208: SELECT COUNT(1)
1209: FROM cn_pay_groups cnpg,
1210: cn_period_statuses cnps
1211: WHERE cnpg.pay_group_id = p_pay_group_id
1212: AND cnpg.period_set_name = cnps.period_set_name
1213: AND cnpg.period_type = cnps.period_type