eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_CCMIGRATE_PVT dependencies on IBY_EXTERNAL_PAYERS_ALL_S

Line 425: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that

421:
422:
423: -- Cursor that queries all transactions needed to be migrated with encryption enabled
424:
425: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that
426: -- the party contexts that are not in the external payer table can be identified.
427: -- 2. The credit card number needs to be numeric.
428: cursor oksline_cur_sec is
429: select

Line 443: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,

439: IV.bill_to_site_use_id,
440: IV.authoring_org_id,
441: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID
442: iby_instr_s.nextval, -- the new credit card 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

Line 482: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that

478: and oksline.id BETWEEN p_id_low AND p_id_high;
479:
480: -- Cursor that queries all transactions needed to be migrated with encryption disable
481:
482: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that
483: -- the party contexts that are not in the external payer table can be identified.
484: -- 2. The credit card number needs to be numeric.
485: cursor oksline_cur is
486: select

Line 500: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,

496: IV.bill_to_site_use_id,
497: IV.authoring_org_id,
498: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID
499: IBY_INSTR_S.nextval, -- the new credit card 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

Line 816: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that

812:
813:
814: -- Cursor that queries all transactions needed to be migrated with encryption enabled
815:
816: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that
817: -- the party contexts that are not in the external payer table can be identified.
818: -- 2. The credit card number needs to be numeric.
819: cursor oksline_cur_sec is
820: select

Line 833: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,

829: IV.bill_to_site_use_id,
830: IV.authoring_org_id,
831: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID
832: iby_instr_s.nextval, -- the new credit card 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

Line 872: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that

868: and oksline.id BETWEEN p_id_low AND p_id_high;
869:
870: -- Cursor that queries all transactions needed to be migrated with encryption disable
871:
872: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that
873: -- the party contexts that are not in the external payer table can be identified.
874: -- 2. The credit card number needs to be numeric.
875: cursor oksline_cur is
876: select

Line 889: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,

885: IV.bill_to_site_use_id,
886: IV.authoring_org_id,
887: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID
888: IBY_INSTR_S.nextval, -- the new credit card 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

Line 1205: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that

1201:
1202:
1203: -- Cursor that queries all transactions needed to be migrated with encryption enabled
1204:
1205: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that
1206: -- the party contexts that are not in the external payer table can be identified.
1207: -- 2. The credit card number needs to be numeric.
1208:
1209: cursor okshdr_cur_sec is

Line 1223: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,

1219: IV.bill_to_site_use_id,
1220: IV.authoring_org_id,
1221: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID
1222: iby_instr_s.nextval, -- the new credit card 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

Line 1264: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that

1260: and okshdr.id BETWEEN p_id_low AND p_id_high;
1261:
1262: -- Cursor that queries all transactions needed to be migrated with encryption disable
1263:
1264: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that
1265: -- the party contexts that are not in the external payer table can be identified.
1266: -- 2. The credit card number needs to be numeric.
1267: cursor okshdr_cur is
1268: select

Line 1281: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,

1277: IV.bill_to_site_use_id,
1278: IV.authoring_org_id,
1279: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID
1280: IBY_INSTR_S.nextval, -- the new credit card 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

Line 1600: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that

1596:
1597:
1598: -- Cursor that queries all transactions needed to be migrated with encryption enabled
1599:
1600: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that
1601: -- the party contexts that are not in the external payer table can be identified.
1602: -- 2. The credit card number needs to be numeric.
1603:
1604: cursor okshdr_cur_sec is

Line 1617: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,

1613: IV.bill_to_site_use_id,
1614: IV.authoring_org_id,
1615: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID
1616: iby_instr_s.nextval, -- the new credit card 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

Line 1658: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that

1654: and okshdr.id BETWEEN p_id_low AND p_id_high;
1655:
1656: -- Cursor that queries all transactions needed to be migrated with encryption disable
1657:
1658: -- Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that
1659: -- the party contexts that are not in the external payer table can be identified.
1660: -- 2. The credit card number needs to be numeric.
1661: cursor okshdr_cur is
1662: select

Line 1674: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,

1670: IV.bill_to_site_use_id,
1671: IV.authoring_org_id,
1672: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID
1673: IBY_INSTR_S.nextval, -- the new credit card 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