APPS.PQP_GB_PSI_WPS_HISTORY dependencies on PAY_ELEMENT_ENTRIES_F

Line 81: FROM pay_element_entries_f pee

77: ,p_input_value_name IN VARCHAR2
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

Line 98: FROM pay_element_entries_f

94: ,p_effective_date IN DATE
95: )
96: IS
97: SELECT entry_type
98: FROM pay_element_entries_f
99: where element_entry_id = p_element_entry_id
100: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
101:
102: CURSOR csr_get_start_date_cut

Line 106: SELECT effective_start_date FROM pay_element_entries_f

102: CURSOR csr_get_start_date_cut
103: (p_element_entry_id IN NUMBER
104: )
105: IS
106: SELECT effective_start_date FROM pay_element_entries_f
107: WHERE element_entry_id = p_element_entry_id
108: AND rownum = 1
109: ORDER BY effective_start_date;
110:

Line 137: FROM pay_element_entries_f

133: c_element_entry_id IN NUMBER
134: )
135: IS
136: SELECT element_type_id
137: FROM pay_element_entries_f
138: WHERE element_entry_id = c_element_entry_id
139: AND rownum=1;
140:
141: -- for 6071527

Line 175: FROM pay_element_entries_f pee

171: ,p_input_value_name IN VARCHAR2
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

Line 196: ,pay_element_entries_f pee

192: )
193: IS
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

Line 216: FROM pay_element_entries_f

212: ,p_assignment_id in number
213: ,p_effective_date in date
214: )
215: IS SELECT effective_end_date
216: FROM pay_element_entries_f
217: WHERE assignment_id = p_assignment_id
218: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
219: AND element_type_id = g_pension_element_type_id;
220: