APPS.AR_RECEIPT_API_PUB dependencies on AR_RR_CRH_GT

Line 10679: from ar_rr_crh_gt;

10675: cc_error_code,
10676: cc_error_text,
10677: cc_instrtype,
10678: 'VALID'
10679: from ar_rr_crh_gt;
10680:
10681: CURSOR cr_exp_rec (p_req_id in number) is
10682: select crhgt.cash_receipt_id
10683: from ar_rr_crh_gt crhgt

Line 10683: from ar_rr_crh_gt crhgt

10679: from ar_rr_crh_gt;
10680:
10681: CURSOR cr_exp_rec (p_req_id in number) is
10682: select crhgt.cash_receipt_id
10683: from ar_rr_crh_gt crhgt
10684: where crhgt.cash_receipt_id
10685: not in
10686: (
10687: select crh.cash_receipt_id

Line 10714: delete from ar_rr_crh_gt;

10710:
10711: /* initiating global table for fresh call*/
10712:
10713: -- IF NOT FND_API.To_Boolean( p_commit ) THEN
10714: delete from ar_rr_crh_gt;
10715: -- END IF;
10716:
10717:
10718: /*Caching variables for setting who columns*/

Line 10744: /*Insert into ar_rr_crh_gt select * from ar_cash_receipt_history*/

10740: END IF;
10741:
10742:
10743: /* Collecting CRH data of passsed receipts*/
10744: /*Insert into ar_rr_crh_gt select * from ar_cash_receipt_history*/
10745: FORALL i IN p_cash_receipts_id.cash_receipt_id.first..p_cash_receipts_id.cash_receipt_id.last
10746: INSERT INTO AR_RR_CRH_GT
10747: (
10748: CASH_RECEIPT_HISTORY_ID,

Line 10746: INSERT INTO AR_RR_CRH_GT

10742:
10743: /* Collecting CRH data of passsed receipts*/
10744: /*Insert into ar_rr_crh_gt select * from ar_cash_receipt_history*/
10745: FORALL i IN p_cash_receipts_id.cash_receipt_id.first..p_cash_receipts_id.cash_receipt_id.last
10746: INSERT INTO AR_RR_CRH_GT
10747: (
10748: CASH_RECEIPT_HISTORY_ID,
10749: CASH_RECEIPT_ID,
10750: STATUS,

Line 10870: and NOT EXISTS (SELECT * FROM AR_RR_CRH_GT WHERE cash_receipt_id = p_cash_receipts_id.cash_receipt_id(i)); -- Bug 13549918

10866: FROM ar_Cash_receipt_history
10867: where cash_receipt_id=p_cash_receipts_id.cash_receipt_id(i)
10868: and current_record_flag = 'Y'
10869: and status = 'REMITTED'
10870: and NOT EXISTS (SELECT * FROM AR_RR_CRH_GT WHERE cash_receipt_id = p_cash_receipts_id.cash_receipt_id(i)); -- Bug 13549918
10871:
10872:
10873: /* Caching data in structure for processing*/
10874: OPEN crh_upd_rec;