APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on IBY_PAYMENTS_ALL

Line 450: FROM iby_payments_all pays

446: RETURN Number
447: IS
448: CURSOR Process_Type IS
449: SELECT pays.process_type
450: FROM iby_payments_all pays
451: ,iby_docs_payable_all docs
452: WHERE pays.payment_id = docs.payment_id
453: AND docs.document_payable_id = P_Doc_Payable_ID;
454:

Line 456: l_process_type iby_payments_all.process_type%Type;

452: WHERE pays.payment_id = docs.payment_id
453: AND docs.document_payable_id = P_Doc_Payable_ID;
454:
455: int_amt number;
456: l_process_type iby_payments_all.process_type%Type;
457:
458: Begin
459: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
460: int_amt := 0;

Line 519: FROM iby_payments_all pays

515: RETURN Number
516: IS
517: CURSOR Process_Type IS
518: SELECT pays.process_type
519: FROM iby_payments_all pays
520: ,iby_docs_payable_all docs
521: WHERE pays.payment_id = docs.payment_id
522: AND docs.document_payable_id = P_Doc_Payable_ID;
523:

Line 525: l_process_type iby_payments_all.process_type%Type;

521: WHERE pays.payment_id = docs.payment_id
522: AND docs.document_payable_id = P_Doc_Payable_ID;
523:
524: abate number;
525: l_process_type iby_payments_all.process_type%Type;
526:
527: Begin
528: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
529: abate := 0;

Line 559: iby_payments_all paym

555: FROM ap_invoice_distributions_all aid,
556: ap_selected_invoices_all asi,
557: iby_docs_payable_all iby,
558: iby_pay_service_requests proc,
559: iby_payments_all paym
560: WHERE aid.invoice_id = asi.invoice_id
561: AND asi.checkrun_name = proc.call_app_pay_service_req_code -- :p_payment_batch
562: AND paym.payment_service_request_id = proc.payment_service_request_id
563: AND iby.payment_id = paym.payment_id