DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1754: l_ele_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;

1750: --
1751: l_proc_name VARCHAR2 (60)
1752: := g_proc_name
1753: || 'get_ele_entry_value';
1754: l_ele_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
1755:
1756: --
1757: BEGIN
1758: debug_enter (l_proc_name);

Line 4811: FROM pay_element_entry_values_f

4807: ,c_effective_end_date DATE
4808: )
4809: IS
4810: SELECT screen_entry_value, effective_start_date, effective_end_date
4811: FROM pay_element_entry_values_f
4812: WHERE element_entry_id = c_element_entry_id
4813: AND (
4814: effective_start_date BETWEEN c_effective_start_date
4815: AND c_effective_end_date

Line 4862: l_ni_category pay_element_entry_values_f.screen_entry_value%TYPE;

4858: j NUMBER;
4859: l_effective_date DATE;
4860: l_return NUMBER;
4861: l_secondary_asg_ids t_number;
4862: l_ni_category pay_element_entry_values_f.screen_entry_value%TYPE;
4863: l_end_date DATE;
4864:
4865: --
4866: BEGIN