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 4216: FROM pay_quickpay_exclusions EXC

4212: (p_use_qpay_excl_model = 'Y'
4213: AND NOT (
4214: EXISTS (
4215: SELECT null
4216: FROM pay_quickpay_exclusions EXC
4217: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4218: AND EXC.element_entry_id = EE.element_entry_id)
4219: OR EXISTS (
4220: SELECT null

Line 4221: FROM pay_quickpay_exclusions EXC

4217: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4218: AND EXC.element_entry_id = EE.element_entry_id)
4219: OR EXISTS (
4220: SELECT null
4221: FROM pay_quickpay_exclusions EXC
4222: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4223: AND EXC.element_entry_id = EE.target_entry_id))
4224: )
4225: )

Line 4273: FROM pay_quickpay_exclusions EXC

4269: (p_use_qpay_excl_model = 'Y'
4270: AND NOT (
4271: EXISTS (
4272: SELECT null
4273: FROM pay_quickpay_exclusions EXC
4274: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4275: AND EXC.element_entry_id = EE.element_entry_id)
4276: OR EXISTS (
4277: SELECT null

Line 4278: FROM pay_quickpay_exclusions EXC

4274: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4275: AND EXC.element_entry_id = EE.element_entry_id)
4276: OR EXISTS (
4277: SELECT null
4278: FROM pay_quickpay_exclusions EXC
4279: WHERE EXC.assignment_action_id = ACT.assignment_action_id
4280: AND EXC.element_entry_id = EE.target_entry_id))
4281: )
4282: )