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