9315: IF x_header_rec.ECE_TP_LOCATION_CODE_EXT is NOT NULL THEN
9316: -- Following query is changed as per TCA obsolescence project.
9317: SELECT ETG.TP_GROUP_CODE
9318: INTO x_tp_group_code
9319: FROM ECE_TP_GROUP ETG,
9320: ECE_TP_HEADERS ETH,
9321: HZ_CUST_ACCT_SITES ACCT_SITE
9322: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9323: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
9397: IF x_header_rec.ECE_TP_LOCATION_CODE_EXT is NOT NULL THEN
9398: -- Following query is changed as per TCA obsolescence project.
9399: SELECT ETG.TP_GROUP_CODE
9400: INTO x_tp_group_code
9401: FROM ECE_TP_GROUP ETG,
9402: ECE_TP_HEADERS ETH,
9403: HZ_CUST_ACCT_SITES ACCT_SITE
9404: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9405: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID