DBA Data[Home] [Help]

APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on PA_ORGANIZATIONS_EXPEND_V

Line 1186: pa_organizations_expend_v

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 */
1190: IF x_destination_type_code = 'EXPENSE' then

Line 1211: FROM pa_organizations_expend_v pou

1207: WHERE pet.expenditure_type = x_expenditure_type
1208: AND pet.system_linkage_function = 'VI';
1209:
1210: SELECT 'Y' into x_valid3
1211: FROM pa_organizations_expend_v pou
1212: WHERE pou.organization_id=x_expenditure_organization_id;
1213: if x_valid1 = 'Y' and x_valid2 = 'Y' and x_valid3 = 'Y' then
1214:
1215: --