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 4195: v_grossup pay_element_entries_f.element_entry_id%TYPE;

4191: v_process_name varchar2(30);
4192: v_first_arg varchar2(30);
4193: v_asactid varchar2(30);
4194: v_asgid varchar2(30);
4195: v_grossup pay_element_entries_f.element_entry_id%TYPE;
4196: v_displ_msg varchar2(30);
4197: --
4198: cursor get_leg_rule is
4199: select rule_mode

Line 4215: pay_element_entries_f EE,

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
4219: AND PACT.payroll_action_id = p_payroll_action_id

Line 4270: pay_element_entries_f 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
4274: WHERE PACT.payroll_action_id = p_payroll_action_id

Line 4328: pay_element_entries_f pee

4324: AND ET.processing_type = 'R'
4325: AND EXISTS ( select ''
4326: from pay_payroll_actions ppa,
4327: per_time_periods ptp,
4328: pay_element_entries_f pee
4329: where pee.element_entry_id = EE.element_entry_id
4330: and ppa.payroll_action_id = ACT.payroll_action_id
4331: and ppa.payroll_id = ptp.payroll_id
4332: and PACT.date_earned between ptp.start_date