DBA Data[Home] [Help]

APPS.RLM_VALIDATEDEMAND_SV dependencies on ECE_TP_GROUP

Line 9319: FROM ECE_TP_GROUP ETG,

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

Line 9401: FROM ECE_TP_GROUP ETG,

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