APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on ZX_REGISTRATIONS

Line 1067: SELECT COUNT(*) INTO l_count FROM ZX_REGISTRATIONS

1063: END;
1064: IF l_reg_number IS NULL THEN
1065: IF l_party_tax_profile_id IS NOT NULL THEN
1066:
1067: SELECT COUNT(*) INTO l_count FROM ZX_REGISTRATIONS
1068: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
1069:
1070: IF l_count = 1 THEN
1071: SELECT REGISTRATION_NUMBER INTO l_reg_number

Line 1072: FROM ZX_REGISTRATIONS

1068: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
1069:
1070: IF l_count = 1 THEN
1071: SELECT REGISTRATION_NUMBER INTO l_reg_number
1072: FROM ZX_REGISTRATIONS
1073: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
1074: ELSIF l_count > 1 THEN
1075: BEGIN
1076: SELECT REGISTRATION_NUMBER INTO l_reg_number

Line 1077: FROM ZX_REGISTRATIONS

1073: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
1074: ELSIF l_count > 1 THEN
1075: BEGIN
1076: SELECT REGISTRATION_NUMBER INTO l_reg_number
1077: FROM ZX_REGISTRATIONS
1078: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id
1079: AND DEFAULT_REGISTRATION_FLAG = 'Y';
1080: EXCEPTION
1081: WHEN OTHERS THEN

Line 1116: SELECT COUNT(*) INTO l_count FROM ZX_REGISTRATIONS

1112:
1113: IF l_reg_number IS NULL THEN
1114: IF l_party_tax_profile_id IS NOT NULL THEN
1115:
1116: SELECT COUNT(*) INTO l_count FROM ZX_REGISTRATIONS
1117: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
1118:
1119: IF l_count = 1 THEN
1120: SELECT REGISTRATION_NUMBER INTO l_reg_number

Line 1121: FROM ZX_REGISTRATIONS

1117: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
1118:
1119: IF l_count = 1 THEN
1120: SELECT REGISTRATION_NUMBER INTO l_reg_number
1121: FROM ZX_REGISTRATIONS
1122: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
1123: ELSIF l_count > 1 THEN
1124: BEGIN
1125: SELECT REGISTRATION_NUMBER INTO l_reg_number

Line 1126: FROM ZX_REGISTRATIONS

1122: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
1123: ELSIF l_count > 1 THEN
1124: BEGIN
1125: SELECT REGISTRATION_NUMBER INTO l_reg_number
1126: FROM ZX_REGISTRATIONS
1127: WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id
1128: AND DEFAULT_REGISTRATION_FLAG = 'Y';
1129: EXCEPTION
1130: WHEN OTHERS THEN