APPS.XNP_CVU_PKG dependencies on XDP_WORKITEMS

Line 1479: FROM xdp_workitems

1475: SELECT workitem_id id, workitem_name name,
1476: to_char(valid_date, gc_DATE_FORMAT) valid_date,
1477: DECODE(invalid_date, NULL, gc_NULL,
1478: to_char(invalid_date, gc_DATE_FORMAT)) invalid_date
1479: FROM xdp_workitems
1480: WHERE invalid_date < SYSDATE;
1481:
1482: CURSOR c_static_wi_no_fe IS
1483: SELECT workitem_id id, workitem_name name

Line 1484: FROM xdp_workitems wi

1480: WHERE invalid_date < SYSDATE;
1481:
1482: CURSOR c_static_wi_no_fe IS
1483: SELECT workitem_id id, workitem_name name
1484: FROM xdp_workitems wi
1485: WHERE wi.wi_type_code = gc_STATIC
1486: AND NOT EXISTS
1487: (SELECT 1
1488: FROM xdp_wi_fa_mapping wfa

Line 1914: FROM wf_process_activities pat, xdp_workitems wi

1910: IS
1911: SELECT pat.process_name process_name,
1912: pat.process_item_type process_item_type,
1913: max(pat.process_version) process_version
1914: FROM wf_process_activities pat, xdp_workitems wi
1915: WHERE
1916: -- xdp_workitem - process
1917: pat.process_name = wi.user_wf_process_name
1918: AND pat.process_item_type = wi.user_wf_item_type

Line 2120: FROM xdp_workitems wi

2116:
2117: CURSOR c_no_special_ia IS
2118:
2119: SELECT DISTINCT wi.user_wf_item_type item_type , workitem_name
2120: FROM xdp_workitems wi
2121: WHERE wi.wi_type_code = 'WORKFLOW'
2122: AND wi.user_wf_item_type IS NOT NULL
2123: AND ( NOT EXISTS
2124: (SELECT 1

Line 2296: FROM wf_process_activities pat, xdp_workitems wi

2292: IS
2293: CURSOR c_wi_processes
2294: IS
2295: SELECT pat.process_item_type, pat.process_name, max(pat.process_version) process_version
2296: FROM wf_process_activities pat, xdp_workitems wi
2297: WHERE
2298: -- xdp_workitem - process
2299: pat.process_name = wi.user_wf_process_name
2300: AND pat.process_item_type = wi.user_wf_item_type

Line 2546: FROM wf_process_activities pat, xdp_workitems wi

2542: IS
2543: SELECT pat.process_name process_name,
2544: pat.process_item_type process_item_type,
2545: max(pat.process_version) process_version
2546: FROM wf_process_activities pat, xdp_workitems wi
2547: WHERE
2548: -- xdp_workitem - process
2549: pat.process_name = wi.user_wf_process_name
2550: AND pat.process_item_type = wi.user_wf_item_type

Line 2634: FROM wf_process_activities pat, xdp_workitems wi

2630: IS
2631: SELECT pat.process_name process_name,
2632: pat.process_item_type process_item_type,
2633: max(pat.process_version) process_version
2634: FROM wf_process_activities pat, xdp_workitems wi
2635: WHERE
2636: -- xdp_workitem - process
2637: pat.process_name = wi.user_wf_process_name
2638: AND pat.process_item_type = wi.user_wf_item_type

Line 2906: FROM xdp_workitems_vl wi

2902: -- WORKITEM
2903:
2904: SELECT count(*)
2905: INTO v_cnt
2906: FROM xdp_workitems_vl wi
2907: WHERE NOT EXISTS
2908: (SELECT 1
2909: FROM wf_lookups wl
2910: WHERE substr(wl.lookup_code,1,29) = substr(wi.workitem_name,1, 29)