APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on PA_EXPENDITURE_TYPES_EXPEND_V

Line 1185: pa_expenditure_types_expend_v

1181: pa_expenditure_types
1182: per_organization_units
1183: needs to be replaced with
1184: pa_projects_expend_v
1185: pa_expenditure_types_expend_v
1186: pa_organizations_expend_v
1187: or else the projects validation would fail.
1188: */
1189: /* Bug 2892199 Added expenditure item date validation */

Line 1206: FROM pa_expenditure_types_expend_v pet

1202: nvl(pat.start_date,x_expenditure_item_date)
1203: AND nvl(pat.completion_date,x_expenditure_item_date) ;
1204:
1205: SELECT 'Y' into x_valid2
1206: FROM pa_expenditure_types_expend_v pet
1207: WHERE pet.expenditure_type = x_expenditure_type
1208: AND pet.system_linkage_function = 'VI';
1209:
1210: SELECT 'Y' into x_valid3