DBA Data[Home] [Help]

APPS.IGC_CC_APPROVAL_WF_PKG dependencies on IGC_CC_ROUTING_CTRLS

Line 1120: FROM igc_cc_routing_ctrls

1116:
1117: CURSOR c_wf_name IS
1118: SELECT wf_approval_itemtype,
1119: wf_approval_process
1120: FROM igc_cc_routing_ctrls
1121: WHERE (org_id,cc_type,cc_state)
1122: IN (
1123: SELECT org_id ,
1124: cc_type ,

Line 2712: FROM igc_cc_routing_ctrls

2708: SELECT pos_structure_version_id
2709: FROM per_pos_structure_versions
2710: WHERE position_structure_id =
2711: ( SELECT default_approval_path_id
2712: FROM igc_cc_routing_ctrls
2713: WHERE org_id = g_org_id
2714: AND cc_type = g_cc_type
2715: AND cc_state = g_cc_state
2716: )