126: IS
127: SELECT party_id_list adhoc_party_list
128: , TRUNC(response_by_date) response_by_date
129: , sysdate
130: FROM ENG_CHANGE_ACTIONS
131: WHERE action_id = p_action_id ;
132:
133:
134: BEGIN
1372:
1373: CURSOR c_action_attr ( p_action_id NUMBER )
1374: IS
1375: SELECT TRUNC(response_by_date) response_by_date
1376: FROM ENG_CHANGE_ACTIONS
1377: WHERE action_id = p_action_id ;
1378:
1379: BEGIN
1380:
1637: CURSOR c_action_attr ( p_action_id NUMBER )
1638: IS
1639: SELECT TRUNC(response_by_date) response_by_date
1640: , sysdate
1641: FROM ENG_CHANGE_ACTIONS
1642: WHERE action_id = p_action_id ;
1643:
1644:
1645: l_debug_flag BOOLEAN := FALSE ; -- For TEST : FALSE ;