DBA Data[Home] [Help]

APPS.CSM_REQUIREMENTS_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 32: FROM csp_requirement_headers h

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: /***

Line 90: FROM CSP_REQUIREMENT_HEADERS

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: