APPS.OKE_BILLING_EVENT_PUB dependencies on PA_PROJECTS_ALL

Line 273: FROM pa_projects_all p

269: SELECT 'X'
270: FROM DUAL
271: WHERE P_ID IN (
272: SELECT P.Project_ID
273: FROM pa_projects_all p
274: WHERE p.Project_ID IN (SELECT To_Number(sub_project_id)
275: FROM pa_fin_structures_links_v
276: START WITH parent_project_id = P_ID1 AND (parent_task_id IN (SELECT Task_ID FROM pa_tasks WHERE Top_Task_ID = P_ID2) or P_ID2 IS NULL)
277: CONNECT BY parent_project_id = PRIOR sub_project_id)

Line 280: FROM pa_projects_all

276: START WITH parent_project_id = P_ID1 AND (parent_task_id IN (SELECT Task_ID FROM pa_tasks WHERE Top_Task_ID = P_ID2) or P_ID2 IS NULL)
277: CONNECT BY parent_project_id = PRIOR sub_project_id)
278: UNION
279: SELECT Project_ID
280: FROM pa_projects_all
281: WHERE Project_ID = P_ID1);
282:
283: CURSOR Seq_C (P_ID NUMBER ) IS
284: SELECT MAX(LEVEL_SEQUENCE)

Line 642: FROM pa_projects_all

638:
639:
640: CURSOR bill_ou IS
641: SELECT org_id
642: FROM pa_projects_all
643: WHERE project_id = p_k_billing_event_rec.bill_project_id;
644:
645:
646:

Line 772: FROM pa_projects_all

768:
769:
770: CURSOR multi_currency_billing_project(C_Project_Id NUMBER) IS
771: SELECT multi_currency_billing_flag
772: FROM pa_projects_all
773: WHERE project_id = C_Project_Id;
774:
775: CURSOR bill_currency(C_header_Id NUMBER) IS
776: SELECT currency_code

Line 1202: FROM pa_projects_all

1198: SELECT segment1
1199: , org_id
1200: , carrying_out_organization_id
1201: , project_level_funding_flag
1202: FROM pa_projects_all
1203: WHERE project_id = C_Project_ID;
1204:
1205:
1206: CURSOR ItemNum ( C_Org_ID NUMBER , C_Item_ID NUMBER ) IS