eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_QPQ_API dependencies on PAY_ELEMENT_TYPES_F

Line 96: INDEX(ELEMENT PAY_ELEMENT_TYPES_F_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)
100: USE_NL(QP_INCL, ENTRY) USE_NL(ENTRY, LINK) USE_NL(LINK, ELEMENT)

Line 108: pay_element_types_f ELEMENT,

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
112: and asgt_action.payroll_action_id = pay_action.payroll_action_id

Line 191: INDEX(ELEMENT PAY_ELEMENT_TYPES_F_PK)

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)
195: USE_NL(LINK, ELEMENT) USE_NL(ELEMENT, CLASS)

Line 202: pay_element_types_f ELEMENT,

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
206: and asgt_action.payroll_action_id = pay_action.payroll_action_id

Line 4213: FROM pay_element_types_f ET,

4209: -- model.
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

Line 4268: FROM pay_element_types_f ET,

4264: AND NOT (ACT.action_status = 'B' AND EE.creator_type = 'RR')
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,