APPS.PQP_GB_PSI_WPS_HISTORY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 65: FROM pay_element_entry_values_f peev

61: ,p_input_value_name IN VARCHAR2
62: )
63: IS
64: SELECT peev.screen_entry_value
65: FROM pay_element_entry_values_f peev
66: ,pay_input_values_f piv
67: WHERE peev.element_entry_id = p_element_entry_id
68: AND piv.input_value_id = peev.input_value_id
69: AND piv.NAME = p_input_value_name

Line 82: ,pay_element_entry_values_f peev

78: )
79: IS
80: SELECT peev.screen_entry_value,peev.element_entry_id
81: FROM pay_element_entries_f pee
82: ,pay_element_entry_values_f peev
83: ,pay_input_values_f piv
84: WHERE pee.assignment_id=p_assignment_id
85: AND pee.element_type_id = p_element_type_id
86: AND peev.element_entry_id = pee.element_entry_id

Line 127: FROM PAY_ELEMENT_ENTRY_VALUES_F

123: p_element_entry_value_id IN NUMBER
124: )
125: IS
126: SELECT element_entry_id
127: FROM PAY_ELEMENT_ENTRY_VALUES_F
128: WHERE element_entry_value_id =p_element_entry_value_id
129: AND ROWNUM=1;
130:
131: CURSOR csr_get_element_type_id

Line 176: ,pay_element_entry_values_f peev

172: )
173: IS
174: SELECT peev.screen_entry_value
175: FROM pay_element_entries_f pee
176: ,pay_element_entry_values_f peev
177: ,pay_input_values_f piv
178: WHERE pee.assignment_id=p_assignment_id
179: AND pee.element_type_id = p_element_type_id
180: AND peev.element_entry_id = pee.element_entry_id

Line 198: ,pay_element_entry_values_f peev

194: SELECT peev.screen_entry_value
195: FROM pay_element_types_f pet
196: ,pay_element_entries_f pee
197: ,pay_element_type_extra_info pete
198: ,pay_element_entry_values_f peev
199: ,pay_input_values_f piv
200: WHERE pee.assignment_id = p_assignment_id -- 301168
201: AND pee.element_type_id = pet.element_type_id -- 172156
202: AND pet.element_name like '%Buy Back FWC'