DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on CSP_REQUIREMENT_LINES

Line 1188: , csp_requirement_lines crl

1184:
1185: CURSOR c_get_reservations is
1186: SELECT 'Y'
1187: FROM csp_req_line_details crld
1188: , csp_requirement_lines crl
1189: , csp_requirement_headers crh
1190: WHERE crh.task_assignment_id = p_task_assignment_id
1191: AND crl.requirement_header_id = crh.requirement_header_id
1192: AND crld.requirement_line_id = crl.requirement_line_id

Line 1198: , csp_requirement_lines crl

1194:
1195: CURSOR c_get_orders is
1196: SELECT 'Y'
1197: FROM csp_req_line_details crld
1198: , csp_requirement_lines crl
1199: , csp_requirement_headers crh
1200: , oe_order_lines_all oel
1201: , oe_order_headers_all oeh
1202: WHERE crh.task_assignment_id = p_task_assignment_id