APPS.PER_IN_PERQUISITE_PKG dependencies on PAY_INPUT_VALUES_F

Line 43: ,pay_input_values_f piv

39: IS
40: SELECT peev.screen_entry_value,
41: peev.element_entry_value_id
42: FROM pay_element_entry_values_f peev
43: ,pay_input_values_f piv
44: WHERE peev.element_entry_id = p_element_entry_id
45: AND piv.name = p_input_name
46: AND peev.input_value_id = piv.input_value_id
47: AND piv.element_Type_id = p_element_type_id

Line 66: FROM pay_input_values_f piv

62: CURSOR c_input_value_id(p_element_type_id NUMBER
63: ,p_input_name VARCHAR2)
64: IS
65: SELECT piv.input_value_id
66: FROM pay_input_values_f piv
67: WHERE piv.element_type_id = p_element_type_id
68: AND piv.NAME = p_input_name
69: AND p_effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
70:

Line 136: TYPE tab_input_value_id IS TABLE OF pay_input_values_f.input_value_id%TYPE INDEX BY BINARY_INTEGER;

132:
133: l_dep_value1 pay_element_entry_values_f.screen_entry_value%TYPE;
134: l_dep_value2 pay_element_entry_values_f.screen_entry_value%TYPE;
135:
136: TYPE tab_input_value_id IS TABLE OF pay_input_values_f.input_value_id%TYPE INDEX BY BINARY_INTEGER;
137: l_input_value_id tab_input_value_id;
138:
139: TYPE tab_element_entry_value IS TABLE OF pay_element_entry_values_f.screen_entry_value%TYPE INDEX BY BINARY_INTEGER;
140: l_element_entry_value tab_element_entry_value;

Line 613: TYPE tab_input_value_name IS TABLE OF pay_input_values_f.name%TYPE INDEX BY BINARY_INTEGER;

609: ,l_element_Type_id NUMBER
610: ,l_assignment_id NUMBER)
611: IS
612: l_first_count NUMBER;
613: TYPE tab_input_value_name IS TABLE OF pay_input_values_f.name%TYPE INDEX BY BINARY_INTEGER;
614: l_input_value_name tab_input_value_name;
615:
616: TYPE tab_effective_date IS TABLE OF DATE INDEX BY BINARY_INTEGER;
617: l_eff_start_date tab_effective_date;