APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 573: from po_distributions_all

569: );
570:
571: cursor c_get_po_dist_account (p_po_distribution_id number) is
572: select accrual_account_id
573: from po_distributions_all
574: where po_distribution_id = p_po_distribution_id;
575:
576: cursor c_get_latest_po_dist_account (p_line_location_id number) is
577: select accrual_account_id

Line 578: from po_distributions_all

574: where po_distribution_id = p_po_distribution_id;
575:
576: cursor c_get_latest_po_dist_account (p_line_location_id number) is
577: select accrual_account_id
578: from po_distributions_all
579: where line_location_id = p_line_location_id
580: and creation_date in
581: (
582: select max(creation_date)

Line 583: from po_distributions_all

579: where line_location_id = p_line_location_id
580: and creation_date in
581: (
582: select max(creation_date)
583: from po_distributions_all
584: where line_location_id = p_line_location_id
585: );
586:
587:

Line 695: ln_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE; /* added by vumaasha for bug 8238608 */

691: lv_orig_currcy_conver_rate rcv_transactions.currency_conversion_rate%type; --added by eric for inclusive tax on 20-dec-2007
692: lv_orig_currcy_conver_date date; --added by eric for inclusive tax on 20-dec-2007
693: r_trx_dtls c_trx_dtls%ROWTYPE; /* added by vumaasha for bug 8238608 */
694: ln_regime_id jai_rgm_definitions.regime_id%TYPE; /* added by vumaasha for bug 8238608 */
695: ln_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE; /* added by vumaasha for bug 8238608 */
696:
697: --added the below cursor for bug#6988610 by eric on Apr 24,2008 ,begin
698: -----------------------------------------------------------------------
699: ln_totl_incl_tax_amount number;