eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_WORK_FLOW dependencies on LNS_EVENTS

Line 363: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt

359: || ' ' || lh.loan_currency loan_undisbursed_amount
360: ,decode(lh.loan_class_code,'ERS','LNS_ERS_CONTEXT_HOMEPAGE_MENU',
361: 'LNS_LOAN_CONTEXT_HOMEPAGE_MENU') function_name
362: ,lh.last_updated_by current_user_id
363: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt
364: WHERE lh.loan_class_code = le.loan_class_code
365: AND le.enabled_flag = 'Y'
366: AND le.event_name = p_event_name
367: AND lt.loan_type_id = lh.loan_type_id

Line 697: FROM lns_events le, lns_event_actions lea

693: , priority_num
694: , nvl(active_for_num,0)*24*60 -- This has to be converted into minutes
695: , delivery_method
696: , event_action_id
697: FROM lns_events le, lns_event_actions lea
698: WHERE le.event_name = p_event_name
699: AND le.enabled_flag = 'Y'
700: AND le.loan_class_code = p_loan_class_code
701: AND lea.event_id = le.event_id

Line 1017: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;

1013: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1014: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1015: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1016: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1017: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1018:
1019: /*-----------------------------------------------------------------------+
1020: | Cursor Declarations |
1021: +-----------------------------------------------------------------------*/

Line 1148: from lns_event_actions ea, lns_events ev,

1144: , LNS_UTILITY_PUB.CREATED_BY
1145: , sysdate
1146: , LNS_UTILITY_PUB.LAST_UPDATED_BY
1147: , LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
1148: from lns_event_actions ea, lns_events ev,
1149: (select loan_class_code, loan_type_id
1150: from lns_loan_types_vl
1151: minus
1152: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id

Line 1153: from lns_events ev, lns_event_actions ea

1149: (select loan_class_code, loan_type_id
1150: from lns_loan_types_vl
1151: minus
1152: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id
1153: from lns_events ev, lns_event_actions ea
1154: where ea.event_id = ev.event_id
1155: and ea.event_action_name = 'NOTIFICATION') missingvalues
1156: where ev.loan_class_code = missingvalues.loan_class_code
1157: and ea.event_id = ev.event_id