35: Function get_increased_index(p_gross_index IN NUMBER, p_effective_date IN date) Return Number IS
36:
37: CURSOR csr_increased_index IS
38: SELECT increased_index
39: FROM pqh_fr_global_indices_f
40: WHERE gross_index = p_gross_index
41: AND type_of_record = 'IND' -- for indices
42: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
43:
40: WHERE gross_index = p_gross_index
41: AND type_of_record = 'IND' -- for indices
42: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
43:
44: l_increased_index pqh_fr_global_indices_f.increased_index%TYPE;
45: BEGIN
46: OPEN csr_increased_index;
47: FETCH csr_increased_index INTO l_increased_index;
48: CLOSE csr_increased_index;
57: p_currency_code IN VARCHAR2 DEFAULT NULL) RETURN NUMBER IS
58:
59: Cursor csr_sal_rate IS
60: SELECT NVL(basic_salary_rate,0), currency_code
61: FROM pqh_fr_global_indices_f
62: WHERE type_of_record = 'INM'
63: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
64:
65: CURSOR csr_gl_currency (p_cet_id IN NUMBER) IS
73: select Precision
74: from Fnd_Currencies
75: where currency_code =p_currency_code;
76:
77: l_gl_currency pqh_fr_global_indices_f.currency_code%TYPE;
78: l_barame_currency pqh_fr_global_indices_f.currency_code%TYPE;
79: l_increased_index pqh_fr_global_indices_f.increased_index%TYPE;
80: l_basic_sal_rate pqh_fr_global_indices_f.basic_salary_rate%TYPE;
81: l_salary_value NUMBER := 0;
74: from Fnd_Currencies
75: where currency_code =p_currency_code;
76:
77: l_gl_currency pqh_fr_global_indices_f.currency_code%TYPE;
78: l_barame_currency pqh_fr_global_indices_f.currency_code%TYPE;
79: l_increased_index pqh_fr_global_indices_f.increased_index%TYPE;
80: l_basic_sal_rate pqh_fr_global_indices_f.basic_salary_rate%TYPE;
81: l_salary_value NUMBER := 0;
82: l_conv_factor NUMBER := 1;
75: where currency_code =p_currency_code;
76:
77: l_gl_currency pqh_fr_global_indices_f.currency_code%TYPE;
78: l_barame_currency pqh_fr_global_indices_f.currency_code%TYPE;
79: l_increased_index pqh_fr_global_indices_f.increased_index%TYPE;
80: l_basic_sal_rate pqh_fr_global_indices_f.basic_salary_rate%TYPE;
81: l_salary_value NUMBER := 0;
82: l_conv_factor NUMBER := 1;
83: l_precision NUMBER;
76:
77: l_gl_currency pqh_fr_global_indices_f.currency_code%TYPE;
78: l_barame_currency pqh_fr_global_indices_f.currency_code%TYPE;
79: l_increased_index pqh_fr_global_indices_f.increased_index%TYPE;
80: l_basic_sal_rate pqh_fr_global_indices_f.basic_salary_rate%TYPE;
81: l_salary_value NUMBER := 0;
82: l_conv_factor NUMBER := 1;
83: l_precision NUMBER;
84:
221:
222: Function get_global_basic_sal_rate(p_effective_date in DATE) RETURN NUMBER IS
223: CURSOR csr_sal_rate IS
224: SELECT basic_salary_rate
225: FROM pqh_fr_global_indices_f
226: WHERE type_of_record = 'INM'
227: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
228:
229: l_sal_rate NUMBER := 0;