APPS.IBY_DISBURSE_SUBMIT_PUB_PKG dependencies on IBY_PAYMENTS_ALL

Line 1589: IBY_PAYMENTS_ALL

1585: );
1586:
1587: END IF;
1588: UPDATE
1589: IBY_PAYMENTS_ALL
1590: SET
1591: payment_status = PAY_STATUS_CREATED
1592: WHERE
1593: payment_service_request_id = l_payreq_id AND

Line 1677: IBY_PAYMENTS_ALL

1673: );
1674:
1675: END IF;
1676: UPDATE
1677: IBY_PAYMENTS_ALL
1678: SET
1679: payment_status = PAY_STATUS_CREATED
1680: WHERE
1681: payment_service_request_id = l_payreq_id AND

Line 2021: FROM iby_payments_all pmts, iby_payment_profiles prof

2017:
2018:
2019: SELECT Count(pmts.payment_id)
2020: INTO l_pmts_invalid_pdoc
2021: FROM iby_payments_all pmts, iby_payment_profiles prof
2022: WHERE pmts.payment_profile_id = prof.payment_profile_id
2023: AND prof.processing_type = 'PRINTED'
2024: AND pmts.payment_service_request_id = l_payreq_id
2025: AND NOT EXISTS (SELECT 'Default Doc in Sync with Acc'

Line 3084: IBY_PAYMENTS_ALL

3080: (
3081: SELECT
3082: payment_id
3083: FROM
3084: IBY_PAYMENTS_ALL
3085: WHERE
3086: payment_service_request_id = l_payreq_id AND
3087: payment_status = PAY_STATUS_MODIFIED
3088: )

Line 3173: IBY_PAYMENTS_ALL

3169: (
3170: SELECT
3171: payment_id
3172: FROM
3173: IBY_PAYMENTS_ALL
3174: WHERE
3175: payment_service_request_id = l_payreq_id AND
3176: payment_status = PAY_STATUS_MOD_BNK_ACC
3177: )