DBA Data[Home] [Help]

APPS.RLM_RD_SV dependencies on ECE_TP_HEADERS

Line 12441: ECE_TP_HEADERS ETH,

12437: -- Following query is changed as per TCA obsolescence project.
12438: SELECT ETG.TP_GROUP_CODE
12439: INTO x_tp_group_code
12440: FROM ECE_TP_GROUP ETG,
12441: ECE_TP_HEADERS ETH,
12442: HZ_CUST_ACCT_SITES ACCT_SITE
12443: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
12444: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
12445: and ACCT_SITE.CUST_ACCOUNT_ID = x_sched_rec.CUSTOMER_ID

Line 12512: ECE_TP_HEADERS ETH,

12508: -- Following query is changed as per TCA obsolescence project.
12509: SELECT ETG.TP_GROUP_CODE
12510: INTO x_tp_group_code
12511: FROM ECE_TP_GROUP ETG,
12512: ECE_TP_HEADERS ETH,
12513: HZ_CUST_ACCT_SITES ACCT_SITE
12514: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
12515: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
12516: and ACCT_SITE.ECE_TP_LOCATION_CODE = v_ECE_TP_LOCATION_CODE_EXT ;