440: B.OBJECT_ID BUDGET_VERSION_BENEFIT
441: INTO
442: L_COST_VERSION_ID, L_BENEFIT_VERSION_ID
443: FROM
444: FPA_VALIDATION_LINES S,
445: FPA_VALIDATION_LINES P,
446: FPA_VALIDATION_LINES C,
447: FPA_VALIDATION_LINES B
448: WHERE
441: INTO
442: L_COST_VERSION_ID, L_BENEFIT_VERSION_ID
443: FROM
444: FPA_VALIDATION_LINES S,
445: FPA_VALIDATION_LINES P,
446: FPA_VALIDATION_LINES C,
447: FPA_VALIDATION_LINES B
448: WHERE
449: S.OBJECT_TYPE = 'BUDGET_VERSIONS_SCENARIO'
442: L_COST_VERSION_ID, L_BENEFIT_VERSION_ID
443: FROM
444: FPA_VALIDATION_LINES S,
445: FPA_VALIDATION_LINES P,
446: FPA_VALIDATION_LINES C,
447: FPA_VALIDATION_LINES B
448: WHERE
449: S.OBJECT_TYPE = 'BUDGET_VERSIONS_SCENARIO'
450: AND S.HEADER_ID IS NULL
443: FROM
444: FPA_VALIDATION_LINES S,
445: FPA_VALIDATION_LINES P,
446: FPA_VALIDATION_LINES C,
447: FPA_VALIDATION_LINES B
448: WHERE
449: S.OBJECT_TYPE = 'BUDGET_VERSIONS_SCENARIO'
450: AND S.HEADER_ID IS NULL
451: AND P.OBJECT_TYPE = 'BUDGET_VERSIONS_PROJ'