APPS.OKE_PA_CHECKS_PUB dependencies on OKE_K_DELIVERABLES_B

Line 39: SELECT project_id FROM oke_k_deliverables_b

35: SELECT project_id FROM oke_k_lines
36: UNION ALL
37: SELECT project_id FROM oke_k_fund_allocations
38: UNION ALL
39: SELECT project_id FROM oke_k_deliverables_b
40: UNION ALL
41: SELECT bill_project_id FROM oke_k_billing_events
42: ) WHERE project_id=l_project_id;
43:

Line 86: SELECT task_id FROM oke_k_deliverables_b

82: SELECT task_id FROM oke_k_lines
83: UNION ALL
84: SELECT task_id FROM oke_k_fund_allocations
85: UNION ALL
86: SELECT task_id FROM oke_k_deliverables_b
87: UNION ALL
88: SELECT bill_task_id FROM oke_k_billing_events
89: ) WHERE task_id=l_task_id;
90:

Line 260: SELECT k_header_id header_id, k_line_id, project_id FROM oke_k_deliverables_b

256: WHERE e.k_line_id=c.id
257: UNION ALL
258: SELECT object_id header_id, k_line_id, project_id FROM oke_k_fund_allocations
259: UNION ALL
260: SELECT k_header_id header_id, k_line_id, project_id FROM oke_k_deliverables_b
261: UNION ALL
262: SELECT k_header_id header_id, NULL, bill_project_id FROM oke_k_billing_events
263: ) WHERE project_id IN (
264: SELECT to_number(object_id_to1) project_id