APPS.LNS_WORK_FLOW dependencies on DUAL

Line 376: FROM dual;

372: ItemType := 'LNSWF';
373:
374: SELECT lns_workflow_itemkey_s.nextval
375: INTO ItemKey
376: FROM dual;
377:
378: OPEN csr_loan_event_details;
379: FETCH csr_loan_event_details
380: INTO l_wf_event_name

Line 864: ELSIF l_primary_recipient_type = 'INDIVIDUAL' AND l_primary_recipient_name =

860: RETURN 'N';
861: end if;
862: l_role_name := 'Loan Managers'|| '(' ||l_loan_number || '-' || ItemKey
863: || ')';
864: ELSIF l_primary_recipient_type = 'INDIVIDUAL' AND l_primary_recipient_name =
865: 'LOAN_ASSIGNED_TO' THEN
866: l_user_roles := l_loan_assigned_user;
867: l_role_name := l_loan_assigned_name || '(' ||l_loan_number || '-'
868: || ItemKey || ')';