29: WHERE l.tranid$$ = b_tranid
30: AND l.clid$$cs = b_user_name
31: AND EXISTS
32: (SELECT 1
33: FROM csp_requirement_headers h
34: WHERE h.requirement_header_id = l.requirement_header_id
35: );
36:
37: CURSOR c_headers_from_inq ( b_user_name VARCHAR2, b_tranid NUMBER) is
85:
86: -- Cursor to retrieve requirement header from Apps
87: CURSOR c_get_requirement_from_apps (b_requirement_header_id NUMBER) is
88: SELECT *
89: FROM CSP_REQUIREMENT_HEADERS
90: WHERE requirement_header_id = b_requirement_header_id;
91:
92: r_get_requirement_from_apps c_get_requirement_from_apps%ROWTYPE;
93: