DBA Data[Home] [Help]

APPS.RLM_BLANKET_SV dependencies on ECE_TP_HEADERS

Line 1043: ECE_TP_HEADERS ETH,

1039: -- Following query is changed as per TCA obsolescence project.
1040: SELECT ETG.TP_GROUP_CODE
1041: INTO x_tp_group_code
1042: FROM ECE_TP_GROUP ETG,
1043: ECE_TP_HEADERS ETH,
1044: HZ_CUST_ACCT_SITES ACCT_SITE
1045: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
1046: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
1047: and ACCT_SITE.CUST_ACCOUNT_ID = x_sched_rec.CUSTOMER_ID