[Home] [Help]
3490: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3491: and exists (select 1
3492: from pay_pre_payments ppp,
3493: pay_org_payment_methods_f pom,
3494: pay_ce_reconciled_payments crp
3495: where ppp.pre_payment_id = act.pre_payment_id
3496: and pom.org_payment_method_id = ppp.org_payment_method_id
3497: and pom.cost_cleared_payment = 'Y'
3498: and crp.assignment_action_id = act.assignment_action_id
3502: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3503: and exists (select 1
3504: from pay_pre_payments ppp,
3505: pay_org_payment_methods_f pom,
3506: pay_ce_reconciled_payments crp
3507: where ppp.pre_payment_id = act.pre_payment_id
3508: and pom.org_payment_method_id = ppp.org_payment_method_id
3509: and pom.cost_cleared_payment = 'Y'
3510: and nvl(pom.exclude_manual_payment, 'N') = 'N'
3518: pay_assignment_actions chq,
3519: pay_payroll_actions pcq,
3520: pay_pre_payments ppp,
3521: pay_org_payment_methods_f pom,
3522: pay_ce_reconciled_payments crp
3523: where int.locking_action_id = act.assignment_action_id
3524: and chq.assignment_action_id = int.locked_action_id
3525: and pcq.payroll_action_id = chq.payroll_action_id
3526: and pcq.action_type = 'H'
3626: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3627: and exists (select 1
3628: from pay_pre_payments ppp,
3629: pay_org_payment_methods_f pom,
3630: pay_ce_reconciled_payments crp
3631: where ppp.pre_payment_id = act.pre_payment_id
3632: and pom.org_payment_method_id = ppp.org_payment_method_id
3633: and pom.cost_cleared_payment = 'Y'
3634: and crp.assignment_action_id = act.assignment_action_id
3638: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3639: and exists (select 1
3640: from pay_pre_payments ppp,
3641: pay_org_payment_methods_f pom,
3642: pay_ce_reconciled_payments crp
3643: where ppp.pre_payment_id = act.pre_payment_id
3644: and pom.org_payment_method_id = ppp.org_payment_method_id
3645: and pom.cost_cleared_payment = 'Y'
3646: and nvl(pom.exclude_manual_payment, 'N') = 'N'
3654: pay_assignment_actions chq,
3655: pay_payroll_actions pcq,
3656: pay_pre_payments ppp,
3657: pay_org_payment_methods_f pom,
3658: pay_ce_reconciled_payments crp
3659: where int.locking_action_id = act.assignment_action_id
3660: and chq.assignment_action_id = int.locked_action_id
3661: and pcq.payroll_action_id = chq.payroll_action_id
3662: and pcq.action_type = 'H'
3766: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3767: and exists (select 1
3768: from pay_pre_payments ppp,
3769: pay_org_payment_methods_f pom,
3770: pay_ce_reconciled_payments crp
3771: where ppp.pre_payment_id = act.pre_payment_id
3772: and pom.org_payment_method_id = ppp.org_payment_method_id
3773: and pom.cost_cleared_payment = 'Y'
3774: and crp.assignment_action_id = act.assignment_action_id
3778: and pa1.batch_process_mode in ('CLEARED', 'ALL')
3779: and exists (select 1
3780: from pay_pre_payments ppp,
3781: pay_org_payment_methods_f pom,
3782: pay_ce_reconciled_payments crp
3783: where ppp.pre_payment_id = act.pre_payment_id
3784: and pom.org_payment_method_id = ppp.org_payment_method_id
3785: and pom.cost_cleared_payment = 'Y'
3786: and nvl(pom.exclude_manual_payment, 'N') = 'N'
3794: pay_assignment_actions chq,
3795: pay_payroll_actions pcq,
3796: pay_pre_payments ppp,
3797: pay_org_payment_methods_f pom,
3798: pay_ce_reconciled_payments crp
3799: where int.locking_action_id = act.assignment_action_id
3800: and chq.assignment_action_id = int.locked_action_id
3801: and pcq.payroll_action_id = chq.payroll_action_id
3802: and pcq.action_type = 'H'