548: );
549:
550: cursor c_get_po_dist_account (p_po_distribution_id number) is
551: select accrual_account_id
552: from po_distributions_all
553: where po_distribution_id = p_po_distribution_id;
554:
555: cursor c_get_latest_po_dist_account (p_line_location_id number) is
556: select accrual_account_id
553: where po_distribution_id = p_po_distribution_id;
554:
555: cursor c_get_latest_po_dist_account (p_line_location_id number) is
556: select accrual_account_id
557: from po_distributions_all
558: where line_location_id = p_line_location_id
559: and creation_date in
560: (
561: select max(creation_date)
558: where line_location_id = p_line_location_id
559: and creation_date in
560: (
561: select max(creation_date)
562: from po_distributions_all
563: where line_location_id = p_line_location_id
564: );
565:
566: