APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1318: FROM pay_element_entry_values_f

1314: -- Cursor to fetch screen entry value
1315: CURSOR csr_get_screen_ent_val
1316: IS
1317: SELECT screen_entry_value
1318: FROM pay_element_entry_values_f
1319: WHERE element_entry_id = p_element_entry_id
1320: AND effective_start_date = p_effective_start_date
1321: AND effective_end_date = p_effective_end_date
1322: AND input_value_id = p_input_value_id;

Line 1327: l_screen_ent_value pay_element_entry_values_f.screen_entry_value%TYPE;

1323:
1324: l_proc_name VARCHAR2(80)
1325: := g_proc_name || 'get_screen_entry_value';
1326: l_proc_step PLS_INTEGER;
1327: l_screen_ent_value pay_element_entry_values_f.screen_entry_value%TYPE;
1328: --
1329: BEGIN
1330: --
1331: IF g_debug

Line 3685: FROM pay_element_entry_values_f

3681: ,c_effective_end_date DATE
3682: )
3683: IS
3684: SELECT screen_entry_value, effective_start_date, effective_end_date
3685: FROM pay_element_entry_values_f
3686: WHERE element_entry_id = c_element_entry_id
3687: AND (
3688: effective_start_date BETWEEN c_effective_start_date
3689: AND c_effective_end_date

Line 3705: l_ni_category pay_element_entry_values_f.screen_entry_value%TYPE;

3701: l_proc_step PLS_INTEGER;
3702: l_rec_screen_ent_val csr_get_screen_ent_val%ROWTYPE;
3703: l_tab_ni_cont_out_bals t_varchar2;
3704: l_effective_end_date DATE;
3705: l_ni_category pay_element_entry_values_f.screen_entry_value%TYPE;
3706: l_ni_pension pay_element_entry_values_f.screen_entry_value%TYPE;
3707: i NUMBER;
3708: l_ni_bal_name t_varchar2;
3709: l_return VARCHAR2(10);

Line 3706: l_ni_pension pay_element_entry_values_f.screen_entry_value%TYPE;

3702: l_rec_screen_ent_val csr_get_screen_ent_val%ROWTYPE;
3703: l_tab_ni_cont_out_bals t_varchar2;
3704: l_effective_end_date DATE;
3705: l_ni_category pay_element_entry_values_f.screen_entry_value%TYPE;
3706: l_ni_pension pay_element_entry_values_f.screen_entry_value%TYPE;
3707: i NUMBER;
3708: l_ni_bal_name t_varchar2;
3709: l_return VARCHAR2(10);
3710: l_index NUMBER;