1042:
1043: -- Following query is changed as per TCA obsolescence project.
1044: SELECT ETG.TP_GROUP_CODE
1045: INTO x_tp_group_code 1046: FROM ECE_TP_GROUP ETG, 1047: ECE_TP_HEADERS ETH,
1048: HZ_CUST_ACCT_SITES ACCT_SITE
1049: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
1050: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID