APPS.OKE_PA_CHECKS_PUB dependencies on OKE_K_FUND_ALLOCATIONS

Line 37: SELECT project_id FROM oke_k_fund_allocations

33: SELECT project_id FROM oke_k_headers
34: UNION ALL
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

Line 84: SELECT task_id FROM oke_k_fund_allocations

80: CURSOR c_used IS
81: SELECT 'Y' FROM (
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

Line 258: SELECT object_id header_id, k_line_id, project_id FROM oke_k_fund_allocations

254: SELECT dnz_chr_id header_id, c.cle_id line_id, project_id
255: FROM oke_k_lines e, okc_k_lines_b c
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