[Home] [Help]
3947: AND pr.party_id = bank.party_id
3948: AND sysdate between pr.effective_start_date and nvl(pr.effective_end_date,sysdate) ;
3949:
3950: -- rct_info rct_info_cur%ROWTYPE;
3951: l_cr_rec ar_cash_receipts_all%ROWTYPE;
3952: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
3953: l_action VARCHAR2(80);
3954: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3955: l_msg_count NUMBER;
4679: a.batch_id,
4680: pr.home_country
4681: FROM ar_autorem_interim a,
4682: /* Need to pass country code for SEPA specific receipts */
4683: ar_cash_receipts_all cr,
4684: ce_bank_acct_uses bau,
4685: ce_bank_accounts cba,
4686: hz_parties bank,
4687: hz_organization_profiles pr
4695: AND sysdate between pr.effective_start_date and nvl(pr.effective_end_date,sysdate) ;
4696:
4697:
4698: /*Bug 7666285*/
4699: CURSOR rct_date_cur (c_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE)
4700: IS
4701: SELECT receipt_date
4702: FROM ar_cash_receipts
4703: WHERE cash_receipt_id = c_cash_receipt_id;
4704:
4705:
4706:
4707: -- rct_info rct_info_cur%ROWTYPE;
4708: l_cr_rec ar_cash_receipts_all%ROWTYPE;
4709: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
4710: l_action VARCHAR2(80);
4711: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4712: l_msg_count NUMBER;
4719: l_amount_rec IBY_FNDCPT_TRXN_PUB.Amount_rec_type;
4720: l_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
4721: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type; /* OUT RESPONSE STRUCTURE */
4722:
4723: l_receipt_date ar_cash_receipts_all.receipt_date%TYPE; /*Bug7666285*/
4724:
4725: /* DECLARE the variables required for the payment engine (AUTH) all the REC TYPES */
4726:
4727: l_payee_rec IBY_FNDCPT_TRXN_PUB.PayeeContext_rec_type;