DBA Data[Home] [Help]

APPS.EDR_STANDARD dependencies on EDR_AMETRAN_INPUT_VAR

Line 639: SELECT INPUT_NAME, DEFAULT_VALUE from EDR_AMETRAN_INPUT_VAR

635:
636: -- 3172322 start: parameterize the cursors on a local transId for duplicated sub-query
637: -- 3172322 start: transName may be changed but 3075902 fix doesn't help here
638: CURSOR C0( the_trans_id VARCHAR2 ) is
639: SELECT INPUT_NAME, DEFAULT_VALUE from EDR_AMETRAN_INPUT_VAR
640: where AME_TRANS_ID = the_trans_id;
641: -- 3172322 end: query on trans id
642:
643: -- 3172322 start: transName may be changed so need to collect all applnames for the same transId

Line 726: SELECT INPUT_NAME, DEFAULT_VALUE from EDR_AMETRAN_INPUT_VAR

722:
723: -- 3172322 start: parameterize the cursors on a local transId for duplicated sub-query
724: -- 3172322 start: transName may be changed but 3075902 fix doesn't help here
725: CURSOR C0( the_trans_id VARCHAR2 ) is
726: SELECT INPUT_NAME, DEFAULT_VALUE from EDR_AMETRAN_INPUT_VAR
727: where AME_TRANS_ID = the_trans_id;
728: -- 3172322 end: query on trans id
729:
730: -- 3172322 start: transName may be changed so need to collect all applnames for the same transId