APPS.PAY_QPQ_API dependencies on PAY_QUICKPAY_INCLUSIONS

Line 93: INDEX(QP_INCL PAY_QUICKPAY_INCLUSIONS_FK2)

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

Line 105: pay_quickpay_inclusions QP_INCL,

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

Line 4224: FROM pay_quickpay_inclusions INC

4220: AND EE.assignment_id = ACT.assignment_id
4221: AND ((p_use_qpay_excl_model = 'N'
4222: AND EXISTS (
4223: SELECT null
4224: FROM pay_quickpay_inclusions INC
4225: WHERE INC.assignment_action_id = ACT.assignment_action_id
4226: AND INC.element_entry_id = EE.element_entry_id)
4227: OR EXISTS (
4228: SELECT null

Line 4229: FROM pay_quickpay_inclusions INC

4225: WHERE INC.assignment_action_id = ACT.assignment_action_id
4226: AND INC.element_entry_id = EE.element_entry_id)
4227: OR EXISTS (
4228: SELECT null
4229: FROM pay_quickpay_inclusions INC
4230: WHERE INC.assignment_action_id = ACT.assignment_action_id
4231: AND INC.element_entry_id = EE.target_entry_id)
4232: )
4233: OR

Line 4281: FROM pay_quickpay_inclusions INC

4277: AND EE.assignment_id = ACT.assignment_id
4278: AND ((p_use_qpay_excl_model = 'N'
4279: AND EXISTS (
4280: SELECT null
4281: FROM pay_quickpay_inclusions INC
4282: WHERE INC.assignment_action_id = ACT.assignment_action_id
4283: AND INC.element_entry_id = EE.element_entry_id)
4284: OR EXISTS (
4285: SELECT null

Line 4286: FROM pay_quickpay_inclusions INC

4282: WHERE INC.assignment_action_id = ACT.assignment_action_id
4283: AND INC.element_entry_id = EE.element_entry_id)
4284: OR EXISTS (
4285: SELECT null
4286: FROM pay_quickpay_inclusions INC
4287: WHERE INC.assignment_action_id = ACT.assignment_action_id
4288: AND INC.element_entry_id = EE.target_entry_id)
4289: )
4290: OR