APPS.PA_FAXFACE dependencies on PA_PROJECTS_ALL

Line 5136: pa_projects_all pp,

5132: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5133: FROM pa_cost_distribution_lines_all pcdl,
5134: pa_expenditure_items_all pei,
5135: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5136: pa_projects_all pp,
5137: pa_project_types pt
5138: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5139: AND pp.project_id = p_project_id
5140: AND pei.project_id = pp.project_id /* added for bug fix :2830211 */

Line 5633: from pa_projects_all p

5629: FOR no_event_proj_rec IN no_event_proj_cur LOOP */
5630:
5631: begin
5632: select 'Y' into is_no_event_proj
5633: from pa_projects_all p
5634: where p.project_id = x_project_id
5635: and NVL(p.capital_event_processing,'N') = 'N';
5636: exception -- Added exception handling for bug 5909337
5637: when no_data_found then

Line 5899: pa_projects_all proj,

5895:
5896: SELECT p_type.capital_cost_type_code
5897: INTO l_capital_cost_type
5898: FROM pa_project_types_all p_type,
5899: pa_projects_all proj,
5900: pa_cost_distribution_lines_all pa_cdl
5901: WHERE p_type.project_type = proj.project_type
5902: AND proj.project_id = pa_cdl.project_id
5903: AND pa_cdl.expenditure_item_id = x_expenditure_item_id