DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on CSP_REQUIREMENT_LINES

Line 1269: , csp_requirement_lines crl

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
1273: AND crld.requirement_line_id = crl.requirement_line_id

Line 1279: , csp_requirement_lines crl

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