DBA Data[Home] [Help]

APPS.CE_BANK_GROUPINGS dependencies on CE_UPG_LOC_REC

Line 1145: insert into ce_upg_loc_rec l

1141: and bank_entity_type = p.BANK_ENTITY_TYPE
1142: and CONTACT_POINT_TYPE = p.CONTACT_POINT_TYPE);
1143:
1144: forall i in c_group_id.first..c_group_id.last
1145: insert into ce_upg_loc_rec l
1146: (CE_UPGRADE_ID,
1147: BANK_ENTITY_TYPE,
1148: UPGRADE_STATUS,
1149: IDENTIFYING_ADDRESS_FLAG,

Line 1189: from ce_upg_loc_rec l

1185: CREATION_DATE,
1186: CREATED_BY,
1187: LAST_UPDATE_DATE,
1188: LAST_UPDATED_BY
1189: from ce_upg_loc_rec l
1190: where ce_upgrade_id = c_upg_id(i)
1191: and IDENTIFYING_ADDRESS_FLAG = 'N'
1192: and not exists
1193: (select null from ce_upg_loc_rec

Line 1193: (select null from ce_upg_loc_rec

1189: from ce_upg_loc_rec l
1190: where ce_upgrade_id = c_upg_id(i)
1191: and IDENTIFYING_ADDRESS_FLAG = 'N'
1192: and not exists
1193: (select null from ce_upg_loc_rec
1194: where ce_upgrade_id = c_group_id(i)
1195: and bank_entity_type = l.BANK_ENTITY_TYPE
1196: and IDENTIFYING_ADDRESS_FLAG = l.IDENTIFYING_ADDRESS_FLAG);
1197: