DBA Data[Home] [Help]

APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on PA_PROJECT_TYPES_ALL

Line 328: FROM pa_project_types_all ptype,

324: AND decode(apid.line_type_lookup_code,'ITEM', null,'ACCRUAL',null,nvl(apid.charge_applicable_to_dist_id, apid.related_id)) =
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

Line 378: FROM pa_project_types_all ptype,

374: AND APIDC.assets_tracking_flag = 'Y')
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

Line 728: FROM pa_project_types_all ptype,

724: AND decode(apid.line_type_lookup_code,'ITEM', null,'ACCRUAL',null,nvl(apid.charge_applicable_to_dist_id, apid.related_id)) =
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

Line 779: FROM pa_project_types_all ptype,

775: AND APIDC.assets_tracking_flag = 'Y')
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