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_ENTRIES_F

Line 94: INDEX(ENTRY PAY_ELEMENT_ENTRIES_F_PK)

90:
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)

Line 106: pay_element_entries_f ENTRY,

102: count (*) TOTAL_OF_ROWS
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

Line 189: INDEX(ENTRY PAY_ELEMENT_ENTRIES_F_N50)

185: ) is
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)

Line 200: pay_element_entries_f ENTRY,

196: USE_NL(CLASS, ENTVAL) */
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

Line 4173: v_grossup pay_element_entries_f.element_entry_id%TYPE;

4169: v_process_name varchar2(30);
4170: v_first_arg varchar2(30);
4171: v_asactid varchar2(30);
4172: v_asgid varchar2(30);
4173: v_grossup pay_element_entries_f.element_entry_id%TYPE;
4174: v_displ_msg varchar2(30);
4175: --
4176: cursor get_leg_rule is
4177: select rule_mode

Line 4193: pay_element_entries_f EE,

4189: cursor get_grossup_entry (p_use_qpay_excl_model varchar2) is
4190: SELECT EE.element_entry_id
4191: FROM pay_element_types_f ET,
4192: pay_element_links_f EL,
4193: pay_element_entries_f EE,
4194: pay_assignment_actions ACT,
4195: pay_payroll_actions PACT
4196: WHERE ACT.assignment_action_id = v_asactid
4197: AND PACT.payroll_action_id = p_payroll_action_id

Line 4248: pay_element_entries_f EE,

4244: UNION ALL
4245: SELECT EE.element_entry_id
4246: FROM pay_element_types_f ET,
4247: pay_element_links_f EL,
4248: pay_element_entries_f EE,
4249: pay_assignment_actions ACT,
4250: pay_payroll_actions PACT,
4251: pay_element_entry_values_f EEV
4252: WHERE PACT.payroll_action_id = p_payroll_action_id

Line 4306: pay_element_entries_f pee

4302: AND ET.processing_type = 'R'
4303: AND EXISTS ( select ''
4304: from pay_payroll_actions ppa,
4305: per_time_periods ptp,
4306: pay_element_entries_f pee
4307: where pee.element_entry_id = EE.element_entry_id
4308: and ppa.payroll_action_id = ACT.payroll_action_id
4309: and ppa.payroll_id = ptp.payroll_id
4310: and PACT.date_earned between ptp.start_date