APPS.PQH_FR_SYNC_SAL_RATES dependencies on PQH_COPY_ENTITY_TXNS

Line 14: g_gl_cet_id pqh_copy_entity_txns.copy_entity_txn_id%TYPE := -1;

10: g_status varchar2(1) := 'S'; -- Status variable defaulted to success
11: -- point value for the salary as of the effective date
12: g_sal_point_rate pqh_fr_global_indices_f.basic_salary_rate%TYPE;
13: g_sal_point_currency pqh_fr_global_indices_f.currency_code%TYPE;
14: g_gl_cet_id pqh_copy_entity_txns.copy_entity_txn_id%TYPE := -1;
15: g_gl_currency_cd pqh_fr_global_indices_f.currency_code%TYPE;
16: g_conv_factor NUMBER := 1;
17: --
18: -- ----------------------------------------------------------------------------

Line 358: pqh_copy_entity_txns cet

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'
362: AND NVL(cer.information173,-9999) = p_ib