APPS.PA_FAXFACE dependencies on PA_PROJECTS_ALL

Line 5522: pa_projects_all pp,

5518: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5519: FROM pa_cost_distribution_lines_all pcdl,
5520: pa_expenditure_items_all pei,
5521: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5522: pa_projects_all pp,
5523: pa_project_types pt
5524: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5525: AND pp.project_id = p_project_id
5526: AND pei.project_id = pp.project_id /* added for bug fix :2830211 */

Line 6019: from pa_projects_all p

6015: FOR no_event_proj_rec IN no_event_proj_cur LOOP */
6016:
6017: begin
6018: select 'Y' into is_no_event_proj
6019: from pa_projects_all p
6020: where p.project_id = x_project_id
6021: and NVL(p.capital_event_processing,'N') = 'N';
6022: exception -- Added exception handling for bug 5909337
6023: when no_data_found then

Line 6345: pa_projects_all proj,

6341:
6342: SELECT p_type.capital_cost_type_code
6343: INTO l_capital_cost_type
6344: FROM pa_project_types_all p_type,
6345: pa_projects_all proj,
6346: pa_cost_distribution_lines_all pa_cdl
6347: WHERE p_type.project_type = proj.project_type
6348: AND proj.project_id = pa_cdl.project_id
6349: AND pa_cdl.expenditure_item_id = x_expenditure_item_id