APPS.PA_ADW_COLLECT_FACTS dependencies on PA_BUDGET_VERSIONS

Line 2221: PA_BUDGET_VERSIONS PBV

2217: -- First mark all the budgets need to be transferred
2218: -- We will transfer the latest baselined budget only
2219:
2220: UPDATE
2221: PA_BUDGET_VERSIONS PBV
2222: SET
2223: ADW_NOTIFY_FLAG = 'S'
2224: WHERE
2225: PROJECT_ID = SEL_PRJS_R.PROJECT_ID

Line 2242: PA_BUDGET_VERSIONS

2238: -- were created. Only those budgets will be refreshed which were sent
2239: -- earlier
2240:
2241: UPDATE
2242: PA_BUDGET_VERSIONS
2243: SET
2244: ADW_NOTIFY_FLAG = 'R'
2245: WHERE
2246: PROJECT_ID = sel_prjs_r.project_id

Line 2252: PA_BUDGET_VERSIONS OB

2248: ( SELECT
2249: BUDGET_TYPE_CODE,
2250: MAX(VERSION_NUMBER)
2251: FROM
2252: PA_BUDGET_VERSIONS OB
2253: WHERE
2254: OB.PROJECT_ID = sel_prjs_r.project_id
2255: AND BUDGET_TYPE_CODE IN
2256: ( SELECT

Line 2267: PA_BUDGET_VERSIONS NB

2263: -- Check if a new budget was baselined, since the time the this budget was sent
2264: ( SELECT
2265: 'YES'
2266: FROM
2267: PA_BUDGET_VERSIONS NB
2268: WHERE
2269: NB.PROJECT_ID = sel_prjs_r.project_id
2270: AND NB.BUDGET_TYPE_CODE = OB.BUDGET_TYPE_CODE
2271: AND NB.ADW_NOTIFY_FLAG = 'S'

Line 2522: PA_BUDGET_VERSIONS

2518: -- PLEASE NOTE THAT WE ARE UPDATING THE BASE TABLE SINCE THE
2519: -- PA_ADW_BUDGETS_V IS DEFINED ON MULTIPLE TABLES
2520:
2521: UPDATE
2522: PA_BUDGET_VERSIONS
2523: SET
2524: ADW_NOTIFY_FLAG = 'N'
2525: WHERE
2526: ADW_NOTIFY_FLAG IN ('S','R');