APPS.OKE_PA_CHECKS_PUB dependencies on OKE_K_BILLING_EVENTS

Line 41: SELECT bill_project_id FROM oke_k_billing_events

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:
44:
45: BEGIN

Line 88: SELECT bill_task_id FROM oke_k_billing_events

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:
91: BEGIN
92:

Line 262: SELECT k_header_id header_id, NULL, bill_project_id FROM oke_k_billing_events

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
265: FROM pa_object_relationships
266: WHERE object_type_from = 'PA_TASKS'