DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on CSP_REQ_LINE_DETAILS

Line 1268: FROM csp_req_line_details crld

1264: l_status varchar2(30);
1265:
1266: CURSOR c_get_reservations is
1267: SELECT 'Y'
1268: FROM csp_req_line_details crld
1269: , csp_requirement_lines crl
1270: , csp_requirement_headers crh
1271: WHERE crh.task_assignment_id = p_task_assignment_id
1272: AND crl.requirement_header_id = crh.requirement_header_id

Line 1278: FROM csp_req_line_details crld

1274: AND crld.source_type = 'RES' ;
1275:
1276: CURSOR c_get_orders is
1277: SELECT 'Y'
1278: FROM csp_req_line_details crld
1279: , csp_requirement_lines crl
1280: , csp_requirement_headers crh
1281: , oe_order_lines_all oel
1282: , oe_order_headers_all oeh