APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on PA_PROJECTS_ALL

Line 329: pa_projects_all proj

325: item.invoice_distribution_id(+)
326: AND ( APID.project_id IS NULL
327: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U') --Call Expanded for Bug 7284987 / 7392117
328: FROM pa_project_types_all ptype,
329: pa_projects_all proj
330: WHERE proj.project_type = ptype.project_type
331: AND ptype.org_id = proj.org_id
332: AND proj.project_id =APID.project_id
333: ) <> 'P'

Line 379: pa_projects_all proj

375: )
376: AND ( APID.project_id IS NULL
377: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U') --Call Expanded for Bug 7284987 / 7392117
378: FROM pa_project_types_all ptype,
379: pa_projects_all proj
380: WHERE proj.project_type = ptype.project_type
381: AND ptype.org_id = proj.org_id
382: AND proj.project_id =APID.project_id
383: ) <> 'P'

Line 729: pa_projects_all proj

725: item.invoice_distribution_id(+)
726: AND ( APID.project_id IS NULL
727: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U') --Call Expanded for Bug 7284987 / 7392117
728: FROM pa_project_types_all ptype,
729: pa_projects_all proj
730: WHERE proj.project_type = ptype.project_type
731: AND ptype.org_id = proj.org_id
732: AND proj.project_id =APID.project_id
733: ) <> 'P'

Line 780: pa_projects_all proj

776: )
777: AND ( APID.project_id IS NULL
778: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U') --Call Expanded for Bug 7284987 / 7392117
779: FROM pa_project_types_all ptype,
780: pa_projects_all proj
781: WHERE proj.project_type = ptype.project_type
782: AND ptype.org_id = proj.org_id
783: AND proj.project_id =APID.project_id
784: ) <> 'P'