APPS.CST_MGD_INFL_ADJUSTMENT_CP dependencies on CST_MGD_INFL_ADJ_PER_STATUSES

Line 27: -- CST_MGD_INFL_ADJ_PER_STATUSES

23: -- COMMENT : This procedure checks whether inflation adjustment processor
24: -- has been run for the organization in that accounting
25: -- period id
26: -- This procedure will use the status table:
27: -- CST_MGD_INFL_ADJ_PER_STATUSES
28: -- USAGE : Used for validation in Transfer_to_GL Process
29: -- EXCEPTIONS: l_infl_processor_run_exc
30: --========================================================================
31: PROCEDURE Check_Inflation_Process_Run (

Line 48: FROM cst_mgd_infl_adj_per_statuses

44: )
45: IS
46: SELECT
47: COUNT(*)
48: FROM cst_mgd_infl_adj_per_statuses
49: WHERE organization_ID = c_org_id
50: AND acct_period_id = c_acct_period_id
51: AND status = 'PROCESS';
52:

Line 130: CST_MGD_INFL_ADJ_PER_STATUSES a

126: COUNT(1)
127: INTO
128: l_status
129: FROM
130: CST_MGD_INFL_ADJ_PER_STATUSES a
131: , ORG_ACCT_PERIODS b
132: WHERE a.Organization_ID = p_org_id
133: AND a.Acct_Period_ID = p_acct_period_id
134: AND a.Status = 'FINAL'

Line 525: CST_MGD_INFL_ADJ_PER_STATUSES

521: -- This is to delete the status record from previous inflation run (if any)
522: -- where the entries are not yet posted to GL
523: -- ========================================================================
524: DELETE FROM
525: CST_MGD_INFL_ADJ_PER_STATUSES
526: WHERE organization_id = p_org_id
527: AND acct_period_id = p_acct_period_id
528: AND status = 'PROCESS';
529: