DBA Data[Home] [Help]

APPS.OKS_CCMIGRATE_PVT dependencies on IBY_PMT_INSTR_USES_ALL_S

Line 447: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id

443: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
444: PAYER.EXT_PAYER_ID),
445: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
446: -- should create new external payer
447: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
448: SEC.cc_number_hash1,
449: SEC.cc_number_hash2,
450: SEC.cc_issuer_range_id,
451: SEC.sec_segment_id,

Line 504: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id

500: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
501: PAYER.EXT_PAYER_ID),
502: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
503: -- should create new external payer
504: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
505: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_FALSE) cc_number_hash1,
506: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_TRUE) cc_number_hash2,
507: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'F') cc_number_hash1,
508: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'T') cc_number_hash2,

Line 837: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id

833: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
834: PAYER.EXT_PAYER_ID),
835: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
836: -- should create new external payer
837: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
838: SEC.cc_number_hash1,
839: SEC.cc_number_hash2,
840: SEC.cc_issuer_range_id,
841: SEC.sec_segment_id,

Line 893: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id

889: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
890: PAYER.EXT_PAYER_ID),
891: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
892: -- should create new external payer
893: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
894: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_FALSE) cc_number_hash1,
895: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_TRUE) cc_number_hash2,
896: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'F') cc_number_hash1,
897: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'T') cc_number_hash2,

Line 1227: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id

1223: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
1224: PAYER.EXT_PAYER_ID),
1225: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
1226: -- should create new external payer
1227: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
1228: SEC.cc_number_hash1,
1229: SEC.cc_number_hash2,
1230: SEC.cc_issuer_range_id,
1231: SEC.sec_segment_id,

Line 1285: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id

1281: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
1282: PAYER.EXT_PAYER_ID),
1283: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
1284: -- should create new external payer
1285: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
1286: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_FALSE) cc_number_hash1,
1287: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_TRUE) cc_number_hash2,
1288: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'F') cc_number_hash1,
1289: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'T') cc_number_hash2,

Line 1621: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id

1617: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
1618: PAYER.EXT_PAYER_ID),
1619: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
1620: -- should create new external payer
1621: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
1622: SEC.cc_number_hash1,
1623: SEC.cc_number_hash2,
1624: SEC.cc_issuer_range_id,
1625: SEC.sec_segment_id,

Line 1678: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id

1674: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
1675: PAYER.EXT_PAYER_ID),
1676: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
1677: -- should create new external payer
1678: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
1679: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_FALSE) cc_number_hash1,
1680: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_TRUE) cc_number_hash2,
1681: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'F') cc_number_hash1,
1682: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'T') cc_number_hash2,