DBA Data[Home] [Help]

APPS.EDR_STANDARD dependencies on EDR_AMERULE_INPUT_VAR

Line 646: from EDR_AMERULE_INPUT_VAR

642:
643: -- 3172322 start: transName may be changed so need to collect all applnames for the same transId
644: CURSOR C1( the_trans_id VARCHAR2 ) is
645: SELECT INPUT_NAME, INPUT_VALUE
646: from EDR_AMERULE_INPUT_VAR
647: where AME_TRANS_NAME in
648: ( select distinct application_name from ame_calling_apps where transaction_type_id = the_trans_id)
649: AND RULE_ID=ameruleid;
650:

Line 733: SELECT INPUT_NAME, INPUT_VALUE from EDR_AMERULE_INPUT_VAR where AME_TRANS_ID = the_trans_id

729:
730: -- 3172322 start: transName may be changed so need to collect all applnames for the same transId
731: CURSOR C1( the_trans_id VARCHAR2 ) is
732: --Bug 5074583: Start
733: SELECT INPUT_NAME, INPUT_VALUE from EDR_AMERULE_INPUT_VAR where AME_TRANS_ID = the_trans_id
734: AND RULE_ID=ameruleid;
735: --Bug 5074583: End
736:
737: l_trans_id varchar2(80);