[Home] [Help]
3482: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3483: and exists (select 1
3484: from pay_pre_payments ppp,
3485: pay_org_payment_methods_f pom,
3486: pay_ce_reconciled_payments crp
3487: where ppp.pre_payment_id = act.pre_payment_id
3488: and pom.org_payment_method_id = ppp.org_payment_method_id
3489: and pom.cost_cleared_payment = 'Y'
3490: and crp.assignment_action_id = act.assignment_action_id
3494: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3495: and exists (select 1
3496: from pay_pre_payments ppp,
3497: pay_org_payment_methods_f pom,
3498: pay_ce_reconciled_payments crp
3499: where ppp.pre_payment_id = act.pre_payment_id
3500: and pom.org_payment_method_id = ppp.org_payment_method_id
3501: and pom.cost_cleared_payment = 'Y'
3502: and pom.exclude_manual_payment = 'N'
3510: pay_assignment_actions chq,
3511: pay_payroll_actions pcq,
3512: pay_pre_payments ppp,
3513: pay_org_payment_methods_f pom,
3514: pay_ce_reconciled_payments crp
3515: where int.locking_action_id = act.assignment_action_id
3516: and chq.assignment_action_id = int.locked_action_id
3517: and pcq.payroll_action_id = chq.payroll_action_id
3518: and pcq.action_type = 'H'
3618: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3619: and exists (select 1
3620: from pay_pre_payments ppp,
3621: pay_org_payment_methods_f pom,
3622: pay_ce_reconciled_payments crp
3623: where ppp.pre_payment_id = act.pre_payment_id
3624: and pom.org_payment_method_id = ppp.org_payment_method_id
3625: and pom.cost_cleared_payment = 'Y'
3626: and crp.assignment_action_id = act.assignment_action_id
3630: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3631: and exists (select 1
3632: from pay_pre_payments ppp,
3633: pay_org_payment_methods_f pom,
3634: pay_ce_reconciled_payments crp
3635: where ppp.pre_payment_id = act.pre_payment_id
3636: and pom.org_payment_method_id = ppp.org_payment_method_id
3637: and pom.cost_cleared_payment = 'Y'
3638: and pom.exclude_manual_payment = 'N'
3646: pay_assignment_actions chq,
3647: pay_payroll_actions pcq,
3648: pay_pre_payments ppp,
3649: pay_org_payment_methods_f pom,
3650: pay_ce_reconciled_payments crp
3651: where int.locking_action_id = act.assignment_action_id
3652: and chq.assignment_action_id = int.locked_action_id
3653: and pcq.payroll_action_id = chq.payroll_action_id
3654: and pcq.action_type = 'H'
3758: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3759: and exists (select 1
3760: from pay_pre_payments ppp,
3761: pay_org_payment_methods_f pom,
3762: pay_ce_reconciled_payments crp
3763: where ppp.pre_payment_id = act.pre_payment_id
3764: and pom.org_payment_method_id = ppp.org_payment_method_id
3765: and pom.cost_cleared_payment = 'Y'
3766: and crp.assignment_action_id = act.assignment_action_id
3770: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3771: and exists (select 1
3772: from pay_pre_payments ppp,
3773: pay_org_payment_methods_f pom,
3774: pay_ce_reconciled_payments crp
3775: where ppp.pre_payment_id = act.pre_payment_id
3776: and pom.org_payment_method_id = ppp.org_payment_method_id
3777: and pom.cost_cleared_payment = 'Y'
3778: and pom.exclude_manual_payment = 'N'
3786: pay_assignment_actions chq,
3787: pay_payroll_actions pcq,
3788: pay_pre_payments ppp,
3789: pay_org_payment_methods_f pom,
3790: pay_ce_reconciled_payments crp
3791: where int.locking_action_id = act.assignment_action_id
3792: and chq.assignment_action_id = int.locked_action_id
3793: and pcq.payroll_action_id = chq.payroll_action_id
3794: and pcq.action_type = 'H'