DBA Data[Home] [Help]

APPS.RLM_VALIDATEDEMAND_SV dependencies on ECE_TP_GROUP

Line 9395: FROM ECE_TP_GROUP ETG,

9391: IF x_header_rec.ECE_TP_LOCATION_CODE_EXT is NOT NULL THEN
9392: -- Following query is changed as per TCA obsolescence project.
9393: SELECT ETG.TP_GROUP_CODE
9394: INTO x_tp_group_code
9395: FROM ECE_TP_GROUP ETG,
9396: ECE_TP_HEADERS ETH,
9397: HZ_CUST_ACCT_SITES ACCT_SITE
9398: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9399: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID

Line 9477: FROM ECE_TP_GROUP ETG,

9473: IF x_header_rec.ECE_TP_LOCATION_CODE_EXT is NOT NULL THEN
9474: -- Following query is changed as per TCA obsolescence project.
9475: SELECT ETG.TP_GROUP_CODE
9476: INTO x_tp_group_code
9477: FROM ECE_TP_GROUP ETG,
9478: ECE_TP_HEADERS ETH,
9479: HZ_CUST_ACCT_SITES ACCT_SITE
9480: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9481: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID