APPS.PAY_QPI_API dependencies on PAY_ELEMENT_TYPES_F

Line 158: pay_element_types_f et

154: --
155: cursor cur_date is
156: select pya.date_earned
157: from
158: pay_element_types_f et
159: , pay_element_links_f el
160: , pay_element_entries_f ent
161: , pay_payroll_actions pya
162: , pay_assignment_actions aga

Line 182: pay_element_types_f et

178: --
179: cursor cur_same is
180: select 'Y'
181: from
182: pay_element_types_f et
183: , pay_element_links_f el
184: , pay_element_entries_f ent
185: , pay_payroll_actions pya
186: , pay_assignment_actions aga

Line 206: from pay_element_types_f ety

202: and aga.assignment_action_id = p_rec.assignment_action_id;
203: --
204: cursor cur_inrun (p_date_earned date) is
205: select 'Y'
206: from pay_element_types_f ety
207: , pay_element_links_f elk
208: , pay_element_entries_f ent
209: where /* Element Types */
210: ety.process_in_run_flag = 'Y'

Line 237: from pay_element_types_f ety

233: and element_entry_id = p_rec.element_entry_id;
234: --
235: cursor cur_fur_ele (p_date_earned date) is
236: select 'Y'
237: from pay_element_types_f ety
238: , pay_element_links_f elk
239: , pay_element_entries_f ent
240: where /*
241: * Element Types

Line 997: from pay_element_types_f ety

993: ,assignment_action_id)
994: select distinct
995: ent.element_entry_id
996: , asa.assignment_action_id
997: from pay_element_types_f ety
998: , pay_element_links_f elk
999: , pay_element_entries_f ent
1000: , pay_payroll_actions pya
1001: , pay_assignment_actions asa