DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1755: l_ele_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;

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

Line 4812: FROM pay_element_entry_values_f

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

Line 4863: l_ni_category pay_element_entry_values_f.screen_entry_value%TYPE;

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