APPS.PAY_QPQ_API dependencies on PAY_ELEMENT_LINKS_F

Line 95: INDEX(LINK PAY_ELEMENT_LINKS_F_PK)

91: select /*+ ORDERED INDEX(PAY_ACTION PAY_PAYROLL_ACTIONS_PK)
92: INDEX(ASGT_ACTION PAY_ASSIGNMENT_ACTIONS_N50)
93: INDEX(QP_INCL PAY_QUICKPAY_INCLUSIONS_FK2)
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)

Line 107: pay_element_links_f LINK,

103: from pay_payroll_actions PAY_ACTION,
104: pay_assignment_actions ASGT_ACTION,
105: pay_quickpay_inclusions QP_INCL,
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

Line 190: INDEX(LINK PAY_ELEMENT_LINKS_F_PK)

186:
187: select /*+ ORDERED INDEX(PAY_ACTION PAY_PAYROLL_ACTIONS_PK)
188: INDEX(ASGT_ACTION PAY_ASSIGNMENT_ACTIONS_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)

Line 201: pay_element_links_f LINK,

197: count (*) TOTAL_OF_ROWS
198: from pay_payroll_actions PAY_ACTION,
199: pay_assignment_actions ASGT_ACTION,
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

Line 4214: pay_element_links_f EL,

4210: --
4211: cursor get_grossup_entry (p_use_qpay_excl_model varchar2) is
4212: SELECT EE.element_entry_id
4213: FROM pay_element_types_f ET,
4214: pay_element_links_f EL,
4215: pay_element_entries_f EE,
4216: pay_assignment_actions ACT,
4217: pay_payroll_actions PACT
4218: WHERE ACT.assignment_action_id = v_asactid

Line 4269: pay_element_links_f EL,

4265: AND NOT (ACT.action_status = 'B' AND EE.creator_type = 'EE')
4266: UNION ALL
4267: SELECT EE.element_entry_id
4268: FROM pay_element_types_f ET,
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