APPS.PER_POSITIONS_PKG dependencies on BEN_COPY_ENTITY_RESULTS

Line 1216: from ben_copy_entity_results

1212: l_show_again_flag varchar2(10) := 'Y';
1213: --
1214: cursor c_show_again(p_user_id number) is
1215: select information12
1216: from ben_copy_entity_results
1217: where copy_entity_txn_id = 0
1218: and table_alias = 'NONE'
1219: and INFORMATION11 = 'PERWSDPO'
1220: and information1 = p_user_id;

Line 1243: from ben_copy_entity_results

1239: l_old_show_again_flag varchar2(10);
1240: --
1241: cursor c_show_again(p_user_id number) is
1242: select information12
1243: from ben_copy_entity_results
1244: where copy_entity_txn_id = 0
1245: and table_alias = 'NONE'
1246: and INFORMATION11 = 'PERWSDPO'
1247: and information1 = p_user_id;

Line 1258: UPDATE ben_copy_entity_results

1254: IF (c_show_again%found) then
1255: --
1256: CLOSE c_show_again;
1257: --
1258: UPDATE ben_copy_entity_results
1259: SET information12 = 'Y',
1260: object_version_number = object_version_number + 1
1261: WHERE copy_entity_txn_id = 0
1262: and table_alias = 'NONE'

Line 1270: INSERT INTO ben_copy_entity_results

1266: ELSE
1267: --
1268: CLOSE c_show_again;
1269: --
1270: INSERT INTO ben_copy_entity_results
1271: (COPY_ENTITY_RESULT_ID, COPY_ENTITY_TXN_ID, RESULT_TYPE_CD,
1272: NUMBER_OF_COPIES, TABLE_ALIAS, STATUS,
1273: DML_OPERATION, DATETRACK_MODE,
1274: INFORMATION1, INFORMATION11, INFORMATION12,

Line 1279: ben_copy_entity_results_s.nextval, 0, 'DISPLAY',

1275: OBJECT_VERSION_NUMBER
1276: )
1277: values
1278: (
1279: ben_copy_entity_results_s.nextval, 0, 'DISPLAY',
1280: 0, 'NONE', 'VALID',
1281: 'INSERT', 'INSERT',
1282: p_user_id, 'PERWSDPO', p_show_again_flag,
1283: 1