APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on ZX_REGISTRATIONS

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

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

Line 1071: FROM ZX_REGISTRATIONS

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

Line 1076: FROM ZX_REGISTRATIONS

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

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

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

Line 1120: FROM ZX_REGISTRATIONS

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

Line 1125: FROM ZX_REGISTRATIONS

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