APPS.PAY_QPQ_API dependencies on PAY_QUICKPAY_EXCLUSIONS

Line 208: /* and entry doesn't exist in Pay_Quickpay_Exclusions */

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
207: and asgt_action.assignment_id = entry.assignment_id
208: /* and entry doesn't exist in Pay_Quickpay_Exclusions */
209: and not (
210: exists (
211: select 'x'
212: from pay_quickpay_exclusions QP_EXCL

Line 212: from pay_quickpay_exclusions QP_EXCL

208: /* and entry doesn't exist in Pay_Quickpay_Exclusions */
209: and not (
210: exists (
211: select 'x'
212: from pay_quickpay_exclusions QP_EXCL
213: where qp_excl.assignment_action_id = asgt_action.assignment_action_id
214: and qp_excl.element_entry_id = entry.element_entry_id
215: )
216: )

Line 4238: FROM pay_quickpay_exclusions EXC

4234: (p_use_qpay_excl_model = 'Y'
4235: AND NOT (
4236: EXISTS (
4237: SELECT null
4238: FROM pay_quickpay_exclusions EXC
4239: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4240: AND EXC.element_entry_id = EE.element_entry_id)
4241: OR EXISTS (
4242: SELECT null

Line 4243: FROM pay_quickpay_exclusions EXC

4239: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4240: AND EXC.element_entry_id = EE.element_entry_id)
4241: OR EXISTS (
4242: SELECT null
4243: FROM pay_quickpay_exclusions EXC
4244: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4245: AND EXC.element_entry_id = EE.target_entry_id))
4246: )
4247: )

Line 4295: FROM pay_quickpay_exclusions EXC

4291: (p_use_qpay_excl_model = 'Y'
4292: AND NOT (
4293: EXISTS (
4294: SELECT null
4295: FROM pay_quickpay_exclusions EXC
4296: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4297: AND EXC.element_entry_id = EE.element_entry_id)
4298: OR EXISTS (
4299: SELECT null

Line 4300: FROM pay_quickpay_exclusions EXC

4296: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4297: AND EXC.element_entry_id = EE.element_entry_id)
4298: OR EXISTS (
4299: SELECT null
4300: FROM pay_quickpay_exclusions EXC
4301: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4302: AND EXC.element_entry_id = EE.target_entry_id))
4303: )
4304: )