DBA Data[Home] [Help]

APPS.JTF_UM_FORGOT_PASSWD dependencies on WF_ITEMS

Line 467: from wf_items wfi, wf_item_attribute_values wfa

463: l_fnd_email_address varchar2(240);
464:
465: cursor C_active_wf_exists is
466: select 'X'
467: from wf_items wfi, wf_item_attribute_values wfa
468: where wfi.item_type = wfa.item_type
469: and wfi.item_key = wfa.item_key
470: and wfi.item_type = 'JTFFPWD'
471: and wfi.end_date is NULL

Line 634: from wf_items wfi, wf_item_attribute_values wfa

630: l_fnd_email_address varchar2(240);
631:
632: cursor C_active_wf_exists is
633: select 'X'
634: from wf_items wfi, wf_item_attribute_values wfa
635: where wfi.item_type = wfa.item_type
636: and wfi.item_key = wfa.item_key
637: and wfi.item_type = 'JTFFPWD'
638: and wfi.end_date is NULL