APPS.IGC_CC_APPROVAL_WF_PKG dependencies on IGC_CC_ACTIONS

Line 2502: IGC_CC_ACTIONS_PKG.Insert_Row

2498: THEN
2499: Put_Debug_Msg( l_full_path,l_api_name||' started');
2500: END IF;
2501:
2502: IGC_CC_ACTIONS_PKG.Insert_Row
2503: ( p_api_version => 1.0,
2504: x_return_status => l_return_status,
2505: x_msg_count => l_msg_count,
2506: x_msg_data => l_msg_data,

Line 3909: FROM igc_cc_actions

3905: FUNCTION Get_Last_App_status
3906: RETURN VARCHAR2 IS
3907: CURSOR c_app_status IS
3908: SELECT cc_action_apprvl_status
3909: FROM igc_cc_actions
3910: WHERE (cc_header_id, cc_action_num)
3911: IN ( SELECT cc_header_id,max(cc_action_num)
3912: FROM igc_cc_actions
3913: WHERE cc_action_state ='PR'

Line 3912: FROM igc_cc_actions

3908: SELECT cc_action_apprvl_status
3909: FROM igc_cc_actions
3910: WHERE (cc_header_id, cc_action_num)
3911: IN ( SELECT cc_header_id,max(cc_action_num)
3912: FROM igc_cc_actions
3913: WHERE cc_action_state ='PR'
3914: AND cc_header_id = g_cc_header_id
3915: GROUP BY cc_header_id) ;
3916:

Line 3917: l_app_status igc_cc_actions.cc_action_apprvl_status%TYPE;

3913: WHERE cc_action_state ='PR'
3914: AND cc_header_id = g_cc_header_id
3915: GROUP BY cc_header_id) ;
3916:
3917: l_app_status igc_cc_actions.cc_action_apprvl_status%TYPE;
3918:
3919: BEGIN
3920:
3921: OPEN c_app_status;