DBA Data[Home] [Help]

APPS.UMX_REG_SERVICES_PKG dependencies on AME_TRANSACTION_TYPES_V

Line 399: l_transaction_type_id AME_TRANSACTION_TYPES_V.transaction_type_id%type;

395: l_BUS_LOGIC_guid_raw WF_EVENTS.guid%type;
396: l_event_name WF_EVENTS.name%type;
397: l_wf_role_name wf_local_roles.name%type;
398: l_reg_function_id fnd_form_functions.function_id%type;
399: l_transaction_type_id AME_TRANSACTION_TYPES_V.transaction_type_id%type;
400:
401: l_start_date date;
402: l_end_date date;
403:

Line 420: from AME_TRANSACTION_TYPES_V ame, fnd_application fa

416: where guid = HEXTORAW(x_guid_raw);
417:
418: CURSOR ame is
419: select ame.TRANSACTION_TYPE_ID, fa.APPLICATION_ID
420: from AME_TRANSACTION_TYPES_V ame, fnd_application fa
421: where nvl(END_DATE,SYSDATE+1) > SYSDATE
422: and fa.application_short_name = X_AME_APP_SHORT_NAME
423: and ame.TRANSACTION_TYPE_ID = X_AME_TRANSACTION_TYPE_ID;
424: