APPS.PQH_FR_SYNC_SAL_RATES dependencies on PQH_FR_GLOBAL_INDICES_F

Line 12: g_sal_point_rate pqh_fr_global_indices_f.basic_salary_rate%TYPE;

8: g_package varchar2(33) := ' pqh_fr_sync_sal_rates.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled; -- check for debug enabled or not
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;

Line 13: g_sal_point_currency pqh_fr_global_indices_f.currency_code%TYPE;

9: g_debug boolean := hr_utility.debug_enabled; -- check for debug enabled or not
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: --

Line 15: g_gl_currency_cd pqh_fr_global_indices_f.currency_code%TYPE;

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: -- ----------------------------------------------------------------------------
19: -- | Private Procedure/Function Definitions |

Line 57: FROM pqh_fr_global_indices_f

53: p_ib10 IN NUMBER Default NULL) IS
54: l_conc_status boolean;
55: CURSOR csr_inm_for_ib (p_ib IN Number) IS
56: SELECT increased_index
57: FROM pqh_fr_global_indices_f
58: WHERE p_effective_date BETWEEN effective_start_date AND effective_end_date
59: AND gross_index = p_ib;
60: l_inm1 NUMBER;
61: l_inm2 NUMBER;

Line 214: FROM pqh_fr_global_indices_f

210: --
211: PROCEDURE sync_all_rates(p_effective_date IN DATE) IS
212: CURSOR csr_all_ib_inms IS
213: SELECT gross_index,increased_index
214: FROM pqh_fr_global_indices_f
215: WHERE p_effective_date BETWEEN effective_start_date AND effective_end_date;
216: l_proc varchar2(72) := g_package||'.sync_all_rates';
217: BEGIN
218: if g_debug then

Line 332: FROM pqh_fr_global_indices_f

328: ,p_basic_sal_rate OUT NOCOPY NUMBER
329: ,p_bareme_currency_cd OUT NOCOPY VARCHAR2) IS
330: CURSOR csr_point_value IS
331: SELECT basic_salary_rate,currency_code
332: FROM pqh_fr_global_indices_f
333: WHERE p_effective_date BETWEEN effective_start_date AND effective_end_date
334: AND type_of_record = 'INM';
335: l_proc varchar2(72) := g_package||'.get_bareme_point_value';
336: BEGIN