APPS.OE_UPGRADE_WF dependencies on OE_UPGRADE_WF_VLD_CYC

Line 856: (SELECT cycle_id, item_type FROM oe_upgrade_wf_vld_cyc ) )

852: AND spr.cycle_action_id IN
853: (SELECT cycle_action_id FROM so_Cycle_actions
854: WHERE cycle_id = p_cycle_id
855: AND (cycle_id, p_item_type) in
856: (SELECT cycle_id, item_type FROM oe_upgrade_wf_vld_cyc ) )
857: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
858: AND spr.result_id NOT IN
859: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes
860: WHERE type ='RESULT'

Line 1189: FROM oe_upgrade_wf_vld_cyc ) );

1185: (SELECT cycle_action_id
1186: FROM so_Cycle_actions
1187: WHERE (cycle_id, 'OEOL') IN
1188: (SELECT cycle_id,item_type
1189: FROM oe_upgrade_wf_vld_cyc ) );
1190:
1191: CURSOR c3 IS
1192: SELECT
1193: pr.instance_id,

Line 3640: AND cycle_id IN (select cycle_id from oe_upgrade_wf_vld_cyc);

3636: where p3.cycle_action_id = p2.cycle_action_id
3637: and p3.group_number = p2.group_number
3638: and p3.action_id = a1.action_id
3639: and a1.result_table = 'SO_HEADERS')))
3640: AND cycle_id IN (select cycle_id from oe_upgrade_wf_vld_cyc);
3641:
3642: cursor c3 is
3643: select cycle_id from so_cycles;
3644:

Line 3730: FROM oe_Upgrade_wf_vld_cyc

3726: V_ERROR_FLAG := 'N';
3727:
3728: BEGIN
3729: SELECT 'Y' INTO v_vld_hdr_flag
3730: FROM oe_Upgrade_wf_vld_cyc
3731: WHERE cycle_id = c2.cycle_id
3732: AND item_type = 'OEOH';
3733: EXCEPTION
3734: WHEN no_data_found THEN

Line 3744: FROM oe_Upgrade_wf_vld_cyc

3740: END;
3741:
3742: BEGIN
3743: SELECT 'Y' INTO v_vld_lin_flag
3744: FROM oe_Upgrade_wf_vld_cyc
3745: WHERE cycle_id = c2.cycle_id
3746: AND item_type = 'OEOL';
3747: EXCEPTION
3748: WHEN no_data_found THEN