APPS.WF_MONITOR dependencies on WF_LOOKUPS

Line 498: wf_lookups l1,

494: wf_activities a,
495: wf_activities_tl a1,
496: wf_item_types_vl ait,
497: wf_item_activity_statuses s,
498: wf_lookups l1,
499: wf_lookups l2,
500: wf_lookup_types art,
501: wf_notifications n
502: where pd.item_type = x_item_type

Line 499: wf_lookups l2,

495: wf_activities_tl a1,
496: wf_item_types_vl ait,
497: wf_item_activity_statuses s,
498: wf_lookups l1,
499: wf_lookups l2,
500: wf_lookup_types art,
501: wf_notifications n
502: where pd.item_type = x_item_type
503: and pd.name = x_proc_parent

Line 534: from wf_lookups l

530:
531: cursor act_result(act_result_type varchar2) is
532: select l.lookup_code,
533: l.meaning
534: from wf_lookups l
535: where l.lookup_type = act_result_type;
536:
537: rc rootproc_info%rowtype;
538:

Line 766: wf_lookups l1,

762: wf_activities_tl a1,
763: wf_item_types_vl ait,
764: wf_item_activity_statuses s,
765: wf_notifications n,
766: wf_lookups l1,
767: wf_lookups l2,
768: wf_lookup_types art
769: where pd.item_type = x_proc_type
770: and pd.name = x_proc_name

Line 767: wf_lookups l2,

763: wf_item_types_vl ait,
764: wf_item_activity_statuses s,
765: wf_notifications n,
766: wf_lookups l1,
767: wf_lookups l2,
768: wf_lookup_types art
769: where pd.item_type = x_proc_type
770: and pd.name = x_proc_name
771: and pd.begin_date <= to_date(x_begin_date, 'DD/MM/YYYY HH24:MI:SS')

Line 800: from wf_lookups l

796:
797: cursor act_result(act_result_type varchar2) is
798: select l.lookup_code,
799: l.meaning
800: from wf_lookups l
801: where l.lookup_type = act_result_type;
802:
803: cursor act_attr(act_item_type varchar2, act_name varchar2,
804: act_version number, act_instance_id number) is

Line 1021: wf_lookups l,

1017: wf_process_activities p1,
1018: wf_activities a,
1019: wf_activity_transitions t,
1020: wf_item_activity_statuses s,
1021: wf_lookups l,
1022: wf_process_activities p2
1023: where pd.item_type = x_proc_type
1024: and pd.name = x_proc_name
1025: and pd.begin_date <= to_date(x_begin_date, 'DD/MM/YYYY HH24:MI:SS')

Line 4164: ** filling in the p_wf_lookups_tbl

4160: OPEN c_get_process_children;
4161:
4162: /*
4163: ** Loop through all the lookup_code rows for the given lookup_type
4164: ** filling in the p_wf_lookups_tbl
4165: */
4166: LOOP
4167:
4168: l_record_num := l_record_num + 1;