APPS.WIP_MOVE_VALIDATOR dependencies on WIP_PERIOD_BALANCES

Line 810: -- specified or there is no WIP_PERIOD_BALANCES

806:
807: -- reset enums table
808: enums.delete;
809: -- Error out if there is no open accout period for the TRANSACTION_DATE
810: -- specified or there is no WIP_PERIOD_BALANCES
811: UPDATE wip_move_txn_interface wmti
812: SET wmti.process_status = WIP_CONSTANTS.ERROR
813: WHERE wmti.group_id = g_group_id
814: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 820: FROM wip_period_balances wpb

816: AND (wmti.acct_period_id IS NULL
817: OR
818: NOT EXISTS
819: (SELECT 'X'
820: FROM wip_period_balances wpb
821: WHERE wpb.acct_period_id = wmti.acct_period_id
822: AND wpb.wip_entity_id = wmti.wip_entity_id
823: AND wpb.organization_id = wmti.organization_id
824: AND (wmti.entity_type IN (WIP_CONSTANTS.DISCRETE,

Line 3183: -- specified or there is no WIP_PERIOD_BALANCES

3179:
3180: -- reset enums table
3181: enums.delete;
3182: -- Error out if there is no open accout period for the TRANSACTION_DATE
3183: -- specified or there is no WIP_PERIOD_BALANCES
3184: UPDATE wip_move_txn_interface wmti
3185: SET wmti.process_status = WIP_CONSTANTS.ERROR
3186: WHERE wmti.group_id = g_group_id
3187: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 3193: FROM wip_period_balances wpb

3189: AND (wmti.acct_period_id IS NULL
3190: OR
3191: NOT EXISTS
3192: (SELECT 'X'
3193: FROM wip_period_balances wpb
3194: WHERE wpb.acct_period_id = wmti.acct_period_id
3195: AND wpb.wip_entity_id = wmti.wip_entity_id
3196: AND wpb.organization_id = wmti.organization_id))
3197: RETURNING wmti.transaction_id BULK COLLECT INTO enums;