APPS.CE_BANK_GROUPINGS dependencies on CE_BANK_UPGRADE_MODES

Line 243: from ce_bank_upgrade_modes

239: --
240: c := '2';
241: select 'Y'
242: into c_grouping_flag
243: from ce_bank_upgrade_modes
244: where source_product_name = 'ALL'
245: and decode(p_bank_entity_type, 'BRANCH', bank_upgrade_mode,
246: 'ACCOUNT', branch_upgrade_mode,'GROUPED') in ('GROUPED','FROZEN')
247: and decode(p_bank_entity_type, 'BANK', bank_upgrade_mode,

Line 744: -- Update GROUPED status to ce_bank_upgrade_modes for 'BANK' level

740: c := '30';
741: close bank_pri;
742:
743: --
744: -- Update GROUPED status to ce_bank_upgrade_modes for 'BANK' level
745: --
746: c := '31';
747: begin
748: update ce_bank_upgrade_modes

Line 748: update ce_bank_upgrade_modes

744: -- Update GROUPED status to ce_bank_upgrade_modes for 'BANK' level
745: --
746: c := '31';
747: begin
748: update ce_bank_upgrade_modes
749: set bank_upgrade_mode = 'GROUPED',
750: last_update_date = sysdate,
751: last_updated_by = nvl(FND_GLOBAL.user_id,-1);
752:

Line 1428: -- Update GROUPED status to ce_bank_upgrade_modes for 'BRANCH' level

1424: c := '78';
1425: close branch_pri;
1426:
1427: --
1428: -- Update GROUPED status to ce_bank_upgrade_modes for 'BRANCH' level
1429: --
1430: c := '79';
1431: begin
1432: update ce_bank_upgrade_modes

Line 1432: update ce_bank_upgrade_modes

1428: -- Update GROUPED status to ce_bank_upgrade_modes for 'BRANCH' level
1429: --
1430: c := '79';
1431: begin
1432: update ce_bank_upgrade_modes
1433: set branch_upgrade_mode = 'GROUPED',
1434: last_update_date = sysdate,
1435: last_updated_by = nvl(FND_GLOBAL.user_id,-1);
1436:

Line 1877: -- Update GROUPED status to ce_bank_upgrade_modes for 'ACCOUNT' level

1873: cep_standard.debug('Total account count='||to_char(tot_count));
1874: end if;
1875:
1876: --
1877: -- Update GROUPED status to ce_bank_upgrade_modes for 'ACCOUNT' level
1878: --
1879: c := '133';
1880: begin
1881: update ce_bank_upgrade_modes

Line 1881: update ce_bank_upgrade_modes

1877: -- Update GROUPED status to ce_bank_upgrade_modes for 'ACCOUNT' level
1878: --
1879: c := '133';
1880: begin
1881: update ce_bank_upgrade_modes
1882: set account_upgrade_mode = 'GROUPED',
1883: last_update_date = sysdate,
1884: last_updated_by = nvl(FND_GLOBAL.user_id,-1);
1885: