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 3114: -- specified or there is no WIP_PERIOD_BALANCES

3110:
3111: -- reset enums table
3112: enums.delete;
3113: -- Error out if there is no open accout period for the TRANSACTION_DATE
3114: -- specified or there is no WIP_PERIOD_BALANCES
3115: UPDATE wip_move_txn_interface wmti
3116: SET wmti.process_status = WIP_CONSTANTS.ERROR
3117: WHERE wmti.group_id = g_group_id
3118: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 3124: FROM wip_period_balances wpb

3120: AND (wmti.acct_period_id IS NULL
3121: OR
3122: NOT EXISTS
3123: (SELECT 'X'
3124: FROM wip_period_balances wpb
3125: WHERE wpb.acct_period_id = wmti.acct_period_id
3126: AND wpb.wip_entity_id = wmti.wip_entity_id
3127: AND wpb.organization_id = wmti.organization_id))
3128: RETURNING wmti.transaction_id BULK COLLECT INTO enums;