APPS.CE_BANK_GROUPINGS dependencies on CE_UPG_CONT_POINT_REC

Line 1063: insert into ce_upg_cont_point_rec

1059: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1060: where ce_upgrade_id = c_group_id(i);
1061:
1062: forall i in c_group_id.first..c_group_id.last
1063: insert into ce_upg_cont_point_rec
1064: (CE_UPGRADE_ID,
1065: BANK_ENTITY_TYPE,
1066: UPGRADE_STATUS,
1067: CONTACT_POINT_TYPE,

Line 1095: from ce_upg_cont_point_rec p

1091: CREATION_DATE,
1092: CREATED_BY,
1093: LAST_UPDATE_DATE,
1094: LAST_UPDATED_BY
1095: from ce_upg_cont_point_rec p
1096: where ce_upgrade_id = c_upg_id(i)
1097: and CONTACT_POINT_TYPE = 'PHONE'
1098: and PHONE_LINE_TYPE in ('FAX', 'PAGER')
1099: and not exists

Line 1100: (select null from ce_upg_cont_point_rec p2

1096: where ce_upgrade_id = c_upg_id(i)
1097: and CONTACT_POINT_TYPE = 'PHONE'
1098: and PHONE_LINE_TYPE in ('FAX', 'PAGER')
1099: and not exists
1100: (select null from ce_upg_cont_point_rec p2
1101: where p2.ce_upgrade_id = c_group_id(i)
1102: and bank_entity_type = p.BANK_ENTITY_TYPE
1103: and CONTACT_POINT_TYPE = p.CONTACT_POINT_TYPE
1104: and PHONE_LINE_TYPE = p.PHONE_LINE_TYPE);

Line 1107: insert into ce_upg_cont_point_rec

1103: and CONTACT_POINT_TYPE = p.CONTACT_POINT_TYPE
1104: and PHONE_LINE_TYPE = p.PHONE_LINE_TYPE);
1105:
1106: forall i in c_group_id.first..c_group_id.last
1107: insert into ce_upg_cont_point_rec
1108: (CE_UPGRADE_ID,
1109: BANK_ENTITY_TYPE,
1110: UPGRADE_STATUS,
1111: CONTACT_POINT_TYPE,

Line 1135: from ce_upg_cont_point_rec p

1131: CREATION_DATE,
1132: CREATED_BY,
1133: LAST_UPDATE_DATE,
1134: LAST_UPDATED_BY
1135: from ce_upg_cont_point_rec p
1136: where ce_upgrade_id = c_upg_id(i)
1137: and CONTACT_POINT_TYPE = 'EMAIL'
1138: and not exists
1139: (select null from ce_upg_cont_point_rec p2

Line 1139: (select null from ce_upg_cont_point_rec p2

1135: from ce_upg_cont_point_rec p
1136: where ce_upgrade_id = c_upg_id(i)
1137: and CONTACT_POINT_TYPE = 'EMAIL'
1138: and not exists
1139: (select null from ce_upg_cont_point_rec p2
1140: where p2.ce_upgrade_id = c_group_id(i)
1141: and bank_entity_type = p.BANK_ENTITY_TYPE
1142: and CONTACT_POINT_TYPE = p.CONTACT_POINT_TYPE);
1143: