APPS.PQH_FR_SYNC_SAL_RATES dependencies on BEN_COPY_ENTITY_RESULTS

Line 357: FROM ben_copy_entity_results cer,

353: p_ib IN NUMBER,
354: p_inm IN NUMBER) IS
355: CURSOR csr_sp_rows_in_stage IS
356: SELECT cer.copy_entity_result_id,cer.copy_entity_txn_id
357: FROM ben_copy_entity_results cer,
358: pqh_copy_entity_txns cet
359: WHERE cer.table_alias = 'OPT'
360: AND cer.dml_operation = 'INSERT'
361: AND NVL(cer.information101,'XXX') = 'FR_PQH'

Line 369: FROM ben_copy_entity_results

365: ORDER BY cer.copy_entity_txn_id;
366:
367: CURSOR csr_gl_currency (p_cet_id IN NUMBER) IS
368: SELECT information50
369: FROM ben_copy_entity_results
370: WHERE copy_entity_txn_id = p_cet_id
371: AND table_alias = 'PGM';
372: --Only Update rates for newly created rows.. as for completed information
373: --the udpates are done already.

Line 376: FROM ben_copy_entity_results

372: --Only Update rates for newly created rows.. as for completed information
373: --the udpates are done already.
374: CURSOR csr_hrrate_rows_in_stage(p_sp_cer_id IN NUMBER, p_cet_id IN NUMBER) IS
375: SELECT copy_entity_result_id,information297
376: FROM ben_copy_entity_results
377: WHERE copy_entity_txn_id = p_cet_id
378: AND table_alias = 'HRRATE'
379: AND dml_operation = 'INSERT'
380: AND information278 = p_sp_cer_id

Line 417: UPDATE ben_copy_entity_results

413:
414:
415: FOR l_hrrate_rec IN csr_hrrate_rows_in_stage(l_sp_rec.copy_entity_result_id,l_sp_rec.copy_entity_txn_id)
416: LOOP
417: UPDATE ben_copy_entity_results
418: SET information297 = NVL(l_new_value,0)
419: WHERE copy_entity_result_id = l_hrrate_rec.copy_entity_result_id;
420: END LOOP;
421: END LOOP;