APPS.OKS_CCMIGRATE_PVT dependencies on IBY_CC_ISSUER_RANGES

Line 464: IBY_CC_ISSUER_RANGES rangE

460: and line.lse_id in (1,12,19,46)
461: and hz.cust_account_id = line.cust_acct_id) IV,
462: IBY_EXTERNAL_PAYERS_ALL payer,
463: IBY_SECURITY_SEGMENTS sec,
464: IBY_CC_ISSUER_RANGES rangE
465: where IV.line_id = oksline.cle_id
466: and oksline.cc_no is not null
467: and oksline.payment_type = 'CCR'
468: and oksline.cc_bank_acct_id is null

Line 854: IBY_CC_ISSUER_RANGES rangE

850: and line.lse_id in (1,12,19,46)
851: and hz.cust_account_id = line.cust_acct_id) IV,
852: IBY_EXTERNAL_PAYERS_ALL payer,
853: IBY_SECURITY_SEGMENTS sec,
854: IBY_CC_ISSUER_RANGES rangE
855: where IV.line_id = oksline.cle_id
856: and oksline.cc_no is not null
857: and oksline.payment_type = 'CCR'
858: and oksline.cc_bank_acct_id is null

Line 1246: IBY_CC_ISSUER_RANGES rangE

1242: and acct.cust_account_id = hz.cust_account_id
1243: and site.site_use_code = 'BILL_TO' ) IV,
1244: IBY_EXTERNAL_PAYERS_ALL payer,
1245: IBY_SECURITY_SEGMENTS sec,
1246: IBY_CC_ISSUER_RANGES rangE
1247: where IV.hdr_id = okshdr.chr_id
1248: and okshdr.cc_no is not null
1249: and okshdr.payment_type = 'CCR'
1250: and okshdr.cc_bank_acct_id is null

Line 1640: IBY_CC_ISSUER_RANGES rangE

1636: and acct.cust_account_id = hz.cust_account_id
1637: and site.site_use_code = 'BILL_TO') IV,
1638: IBY_EXTERNAL_PAYERS_ALL payer,
1639: IBY_SECURITY_SEGMENTS sec,
1640: IBY_CC_ISSUER_RANGES rangE
1641: where IV.hdr_id = okshdr.chr_id
1642: and okshdr.cc_no is not null
1643: and okshdr.payment_type = 'CCR'
1644: and okshdr.cc_bank_acct_id is null