APPS.CSTPPACQ dependencies on RCV_RECEIVING_SUB_LEDGER

Line 4827: FROM rcv_receiving_sub_ledger rsl

4823: l_stmt_num := 10;
4824:
4825: SELECT count(rcv_transaction_id)
4826: INTO l_rsl_exists
4827: FROM rcv_receiving_sub_ledger rsl
4828: WHERE rsl.rcv_transaction_id = i_rcv_txn_id
4829: AND rsl.accounted_cr IS NOT NULL
4830: AND rsl.accounted_cr <> 0
4831: AND ROWNUM < 2;

Line 4872: rcv_receiving_sub_ledger rsl,

4868: SUM(rsl.accounted_cr) / SUM(rsl.entered_cr)
4869: INTO
4870: l_po_rate
4871: FROM
4872: rcv_receiving_sub_ledger rsl,
4873: rcv_accounting_events rae
4874: WHERE
4875: rsl.rcv_transaction_id = i_rcv_txn_id AND
4876: rsl.accounted_cr is not null AND

Line 4889: rcv_receiving_sub_ledger rsl

4885: SUM(rsl.accounted_cr) / SUM(rsl.entered_cr)
4886: INTO
4887: l_po_rate
4888: FROM
4889: rcv_receiving_sub_ledger rsl
4890: WHERE
4891: rsl.rcv_transaction_id = i_rcv_txn_id AND
4892: rsl.accounted_cr is not null AND
4893: rsl.accounted_cr <> 0;