DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on CSP_REQUIREMENT_HEADERS

Line 1270: , csp_requirement_headers crh

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
1273: AND crld.requirement_line_id = crl.requirement_line_id
1274: AND crld.source_type = 'RES' ;

Line 1280: , csp_requirement_headers crh

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
1283: WHERE crh.task_assignment_id = p_task_assignment_id
1284: AND crl.requirement_header_id = crh.requirement_header_id