APPS.PAY_QPQ_API dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 98: INDEX(ENTVAL PAY_ELEMENT_ENTRY_VALUES_F_N50)

94: INDEX(ENTRY PAY_ELEMENT_ENTRIES_F_PK)
95: INDEX(LINK PAY_ELEMENT_LINKS_F_PK)
96: INDEX(ELEMENT PAY_ELEMENT_TYPES_F_PK)
97: INDEX(CLASS PAY_ELEMENT_CLASSIFICATION_PK)
98: INDEX(ENTVAL PAY_ELEMENT_ENTRY_VALUES_F_N50)
99: USE_NL(PAY_ACTION, ASGT_ACTION) USE_NL(ASGT_ACTION, QP_INCL)
100: USE_NL(QP_INCL, ENTRY) USE_NL(ENTRY, LINK) USE_NL(LINK, ELEMENT)
101: USE_NL(ELEMENT, CLASS) USE_NL(CLASS, ENTVAL) */
102: count (*) TOTAL_OF_ROWS

Line 110: pay_element_entry_values_f ENTVAL

106: pay_element_entries_f ENTRY,
107: pay_element_links_f LINK,
108: pay_element_types_f ELEMENT,
109: pay_element_classifications CLASS,
110: pay_element_entry_values_f ENTVAL
111: where pay_action.payroll_action_id = PI_PAYROLL_ACTION_ID
112: and asgt_action.payroll_action_id = pay_action.payroll_action_id
113: and asgt_action.assignment_action_id = qp_incl.assignment_action_id
114: and qp_incl.element_entry_id = entry.element_entry_id

Line 193: INDEX(ENTVAL PAY_ELEMENT_ENTRY_VALUES_F_N50)

189: INDEX(ENTRY PAY_ELEMENT_ENTRIES_F_N50)
190: INDEX(LINK PAY_ELEMENT_LINKS_F_PK)
191: INDEX(ELEMENT PAY_ELEMENT_TYPES_F_PK)
192: INDEX(CLASS PAY_ELEMENT_CLASSIFICATION_PK)
193: INDEX(ENTVAL PAY_ELEMENT_ENTRY_VALUES_F_N50)
194: USE_NL(PAY_ACTION, ASGT_ACTION) USE_NL(ENTRY, LINK)
195: USE_NL(LINK, ELEMENT) USE_NL(ELEMENT, CLASS)
196: USE_NL(CLASS, ENTVAL) */
197: count (*) TOTAL_OF_ROWS

Line 204: pay_element_entry_values_f ENTVAL

200: pay_element_entries_f ENTRY,
201: pay_element_links_f LINK,
202: pay_element_types_f ELEMENT,
203: pay_element_classifications CLASS,
204: pay_element_entry_values_f ENTVAL
205: where pay_action.payroll_action_id = PI_PAYROLL_ACTION_ID
206: and asgt_action.payroll_action_id = pay_action.payroll_action_id
207: and asgt_action.assignment_id = entry.assignment_id
208: /* and entry doesn't exist in Pay_Quickpay_Exclusions */

Line 4273: pay_element_entry_values_f EEV

4269: pay_element_links_f EL,
4270: pay_element_entries_f EE,
4271: pay_assignment_actions ACT,
4272: pay_payroll_actions PACT,
4273: pay_element_entry_values_f EEV
4274: WHERE PACT.payroll_action_id = p_payroll_action_id
4275: and PACT.payroll_action_id = ACT.payroll_action_id
4276: and ACT.action_status not in ('C', 'S')
4277: AND EE.assignment_id = ACT.assignment_id