DBA Data[Home] [Help]

APPS.CST_MGD_INFL_ADJUSTMENT_PVT dependencies on CST_MGD_INFL_ADJ_PER_STATUSES

Line 156: CST_MGD_INFL_ADJ_PER_STATUSES

152: WHERE Organization_ID = p_organization_id
153: AND Acct_Period_ID = (SELECT
154: MAX(Acct_Period_ID)
155: FROM
156: CST_MGD_INFL_ADJ_PER_STATUSES
157: WHERE Organization_ID = p_organization_id
158: AND Status = 'FINAL')
159: AND Open_Flag = 'N'
160: AND Period_Close_Date IS NOT NULL;

Line 2551: CST_MGD_INFL_ADJ_PER_STATUSES(

2547:
2548: x_return_status := FND_API.G_RET_STS_SUCCESS;
2549:
2550: INSERT INTO
2551: CST_MGD_INFL_ADJ_PER_STATUSES(
2552: Organization_ID
2553: , Acct_Period_ID
2554: , Last_Update_Date
2555: , Last_Updated_By

Line 2623: UPDATE CST_MGD_INFL_ADJ_PER_STATUSES

2619: BEGIN
2620:
2621: x_return_status := FND_API.G_RET_STS_SUCCESS;
2622:
2623: UPDATE CST_MGD_INFL_ADJ_PER_STATUSES
2624: SET Status = 'FINAL'
2625: , Last_Update_Date = SYSDATE
2626: , Last_Updated_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2627: , Creation_Date = SYSDATE