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.ZX_MIGRATE_TAX_DEF_COMMON dependencies on FND_GLOBAL

Line 108: fnd_global.user_id created_by,

104: 'N' frozen,
105: zx_migrate_util.get_country(codes.org_id) country_code,
106: codes.start_date effective_from,
107: codes.inactive_date effective_to,
108: fnd_global.user_id created_by,
109: sysdate creation_date,
110: fnd_global.user_id last_updated_by,
111: sysdate last_updated_date,
112: fnd_global.conc_login_id last_update_login

Line 110: fnd_global.user_id last_updated_by,

106: codes.start_date effective_from,
107: codes.inactive_date effective_to,
108: fnd_global.user_id created_by,
109: sysdate creation_date,
110: fnd_global.user_id last_updated_by,
111: sysdate last_updated_date,
112: fnd_global.conc_login_id last_update_login
113: FROM ap_tax_codes_all codes,
114: financials_system_params_all fsp

Line 112: fnd_global.conc_login_id last_update_login

108: fnd_global.user_id created_by,
109: sysdate creation_date,
110: fnd_global.user_id last_updated_by,
111: sysdate last_updated_date,
112: fnd_global.conc_login_id last_update_login
113: FROM ap_tax_codes_all codes,
114: financials_system_params_all fsp
115: WHERE codes.tax_type NOT IN ('AWT','TAX_GROUP','OFFSET')
116: AND codes.org_id = fsp.org_id

Line 214: fnd_global.user_id created_by,

210: 'N' frozen,
211: zx_migrate_util.get_country(codes.org_id) country_code,
212: codes.start_date effective_from,
213: codes.inactive_date effective_to,
214: fnd_global.user_id created_by,
215: sysdate creation_date,
216: fnd_global.user_id last_updated_by,
217: sysdate last_updated_date,
218: fnd_global.conc_login_id last_update_login

Line 216: fnd_global.user_id last_updated_by,

212: codes.start_date effective_from,
213: codes.inactive_date effective_to,
214: fnd_global.user_id created_by,
215: sysdate creation_date,
216: fnd_global.user_id last_updated_by,
217: sysdate last_updated_date,
218: fnd_global.conc_login_id last_update_login
219: FROM ap_tax_codes_all codes,
220: financials_system_params_all fsp

Line 218: fnd_global.conc_login_id last_update_login

214: fnd_global.user_id created_by,
215: sysdate creation_date,
216: fnd_global.user_id last_updated_by,
217: sysdate last_updated_date,
218: fnd_global.conc_login_id last_update_login
219: FROM ap_tax_codes_all codes,
220: financials_system_params_all fsp
221: WHERE codes.tax_type NOT IN ('AWT','TAX_GROUP','OFFSET')
222: AND codes.org_id = fsp.org_id

Line 319: fnd_global.user_id created_by,

315: 'N' frozen,
316: zx_migrate_util.get_country(offset.org_id) country_code,
317: offset.start_date effective_from,
318: offset.inactive_date effective_to,
319: fnd_global.user_id created_by,
320: sysdate creation_date,
321: fnd_global.user_id last_updated_by,
322: sysdate last_updated_date,
323: fnd_global.conc_login_id last_update_login

Line 321: fnd_global.user_id last_updated_by,

317: offset.start_date effective_from,
318: offset.inactive_date effective_to,
319: fnd_global.user_id created_by,
320: sysdate creation_date,
321: fnd_global.user_id last_updated_by,
322: sysdate last_updated_date,
323: fnd_global.conc_login_id last_update_login
324: FROM ap_tax_codes_all codes,
325: ap_tax_codes_all offset,

Line 323: fnd_global.conc_login_id last_update_login

319: fnd_global.user_id created_by,
320: sysdate creation_date,
321: fnd_global.user_id last_updated_by,
322: sysdate last_updated_date,
323: fnd_global.conc_login_id last_update_login
324: FROM ap_tax_codes_all codes,
325: ap_tax_codes_all offset,
326: financials_system_params_all fsp
327: WHERE offset.tax_type = 'OFFSET'

Line 423: fnd_global.user_id created_by,

419: 'N' frozen,
420: zx_migrate_util.get_country(offset.org_id) country_code,
421: offset.start_date effective_from,
422: offset.inactive_date effective_to,
423: fnd_global.user_id created_by,
424: sysdate creation_date,
425: fnd_global.user_id last_updated_by,
426: sysdate last_updated_date,
427: fnd_global.conc_login_id last_update_login

Line 425: fnd_global.user_id last_updated_by,

421: offset.start_date effective_from,
422: offset.inactive_date effective_to,
423: fnd_global.user_id created_by,
424: sysdate creation_date,
425: fnd_global.user_id last_updated_by,
426: sysdate last_updated_date,
427: fnd_global.conc_login_id last_update_login
428: FROM ap_tax_codes_all codes,
429: ap_tax_codes_all offset,

Line 427: fnd_global.conc_login_id last_update_login

423: fnd_global.user_id created_by,
424: sysdate creation_date,
425: fnd_global.user_id last_updated_by,
426: sysdate last_updated_date,
427: fnd_global.conc_login_id last_update_login
428: FROM ap_tax_codes_all codes,
429: ap_tax_codes_all offset,
430: financials_system_params_all fsp
431: WHERE offset.tax_type = 'OFFSET'

Line 501: fnd_global.user_id created_by,

497: 'N' frozen,
498: zx_migrate_util.get_country(offset.org_id) country_code,
499: offset.start_date effective_from,
500: offset.inactive_date effective_to,
501: fnd_global.user_id created_by,
502: sysdate creation_date,
503: fnd_global.user_id last_updated_by,
504: sysdate last_updated_date,
505: fnd_global.conc_login_id last_update_login

Line 503: fnd_global.user_id last_updated_by,

499: offset.start_date effective_from,
500: offset.inactive_date effective_to,
501: fnd_global.user_id created_by,
502: sysdate creation_date,
503: fnd_global.user_id last_updated_by,
504: sysdate last_updated_date,
505: fnd_global.conc_login_id last_update_login
506: FROM
507: ap_tax_codes_all offset,

Line 505: fnd_global.conc_login_id last_update_login

501: fnd_global.user_id created_by,
502: sysdate creation_date,
503: fnd_global.user_id last_updated_by,
504: sysdate last_updated_date,
505: fnd_global.conc_login_id last_update_login
506: FROM
507: ap_tax_codes_all offset,
508: financials_system_params_all fsp
509: WHERE offset.tax_type = 'OFFSET'

Line 571: fnd_global.user_id created_by,

567: 'N' frozen,
568: zx_migrate_util.get_country(offset.org_id) country_code,
569: offset.start_date effective_from,
570: offset.inactive_date effective_to,
571: fnd_global.user_id created_by,
572: sysdate creation_date,
573: fnd_global.user_id last_updated_by,
574: sysdate last_updated_date,
575: fnd_global.conc_login_id last_update_login

Line 573: fnd_global.user_id last_updated_by,

569: offset.start_date effective_from,
570: offset.inactive_date effective_to,
571: fnd_global.user_id created_by,
572: sysdate creation_date,
573: fnd_global.user_id last_updated_by,
574: sysdate last_updated_date,
575: fnd_global.conc_login_id last_update_login
576: FROM
577: ap_tax_codes_all offset,

Line 575: fnd_global.conc_login_id last_update_login

571: fnd_global.user_id created_by,
572: sysdate creation_date,
573: fnd_global.user_id last_updated_by,
574: sysdate last_updated_date,
575: fnd_global.conc_login_id last_update_login
576: FROM
577: ap_tax_codes_all offset,
578: financials_system_params_all fsp
579: WHERE offset.tax_type = 'OFFSET'

Line 694: fnd_global.user_id created_by,

690: 'N' frozen,
691: zx_migrate_util.get_country(codes.org_id) country_code,
692: codes.start_date effective_from,
693: codes.end_date effective_to,
694: fnd_global.user_id created_by,
695: sysdate creation_date,
696: fnd_global.user_id last_updated_by,
697: sysdate last_updated_date,
698: fnd_global.conc_login_id last_update_login

Line 696: fnd_global.user_id last_updated_by,

692: codes.start_date effective_from,
693: codes.end_date effective_to,
694: fnd_global.user_id created_by,
695: sysdate creation_date,
696: fnd_global.user_id last_updated_by,
697: sysdate last_updated_date,
698: fnd_global.conc_login_id last_update_login
699: FROM ar_vat_tax_all_b codes,
700: ar_system_parameters_all asp

Line 698: fnd_global.conc_login_id last_update_login

694: fnd_global.user_id created_by,
695: sysdate creation_date,
696: fnd_global.user_id last_updated_by,
697: sysdate last_updated_date,
698: fnd_global.conc_login_id last_update_login
699: FROM ar_vat_tax_all_b codes,
700: ar_system_parameters_all asp
701: WHERE codes.tax_type not in ('TAX_GROUP', 'LOCATION')
702: AND asp.org_id = codes.org_id

Line 816: fnd_global.user_id created_by,

812: 'N' frozen,
813: zx_migrate_util.get_country(codes.org_id) country_code,
814: codes.start_date effective_from,
815: codes.end_date effective_to,
816: fnd_global.user_id created_by,
817: sysdate creation_date,
818: fnd_global.user_id last_updated_by,
819: sysdate last_updated_date,
820: fnd_global.conc_login_id last_update_login

Line 818: fnd_global.user_id last_updated_by,

814: codes.start_date effective_from,
815: codes.end_date effective_to,
816: fnd_global.user_id created_by,
817: sysdate creation_date,
818: fnd_global.user_id last_updated_by,
819: sysdate last_updated_date,
820: fnd_global.conc_login_id last_update_login
821: FROM ar_vat_tax_all_b codes,
822: ar_system_parameters_all asp

Line 820: fnd_global.conc_login_id last_update_login

816: fnd_global.user_id created_by,
817: sysdate creation_date,
818: fnd_global.user_id last_updated_by,
819: sysdate last_updated_date,
820: fnd_global.conc_login_id last_update_login
821: FROM ar_vat_tax_all_b codes,
822: ar_system_parameters_all asp
823: WHERE codes.tax_type not in ('TAX_GROUP', 'LOCATION')
824: AND asp.org_id = codes.org_id

Line 976: fnd_global.user_id created_by,

972: 'N' frozen,
973: zx_migrate_util.get_country(codes.org_id) country_code,
974: codes.start_date effective_from,
975: codes.end_date effective_to,
976: fnd_global.user_id created_by,
977: sysdate creation_date,
978: fnd_global.user_id last_updated_by,
979: sysdate last_updated_date,
980: fnd_global.conc_login_id last_update_login

Line 978: fnd_global.user_id last_updated_by,

974: codes.start_date effective_from,
975: codes.end_date effective_to,
976: fnd_global.user_id created_by,
977: sysdate creation_date,
978: fnd_global.user_id last_updated_by,
979: sysdate last_updated_date,
980: fnd_global.conc_login_id last_update_login
981: FROM ar_vat_tax_all_b codes,
982: ar_system_parameters_all asp,

Line 980: fnd_global.conc_login_id last_update_login

976: fnd_global.user_id created_by,
977: sysdate creation_date,
978: fnd_global.user_id last_updated_by,
979: sysdate last_updated_date,
980: fnd_global.conc_login_id last_update_login
981: FROM ar_vat_tax_all_b codes,
982: ar_system_parameters_all asp,
983: zx_tax_priorities_t zxpt
984:

Line 1095: fnd_global.user_id created_by,

1091: 'N' frozen,
1092: zx_migrate_util.get_country(codes.org_id) country_code,
1093: codes.start_date effective_from,
1094: codes.end_date effective_to,
1095: fnd_global.user_id created_by,
1096: sysdate creation_date,
1097: fnd_global.user_id last_updated_by,
1098: sysdate last_updated_date,
1099: fnd_global.conc_login_id last_update_login

Line 1097: fnd_global.user_id last_updated_by,

1093: codes.start_date effective_from,
1094: codes.end_date effective_to,
1095: fnd_global.user_id created_by,
1096: sysdate creation_date,
1097: fnd_global.user_id last_updated_by,
1098: sysdate last_updated_date,
1099: fnd_global.conc_login_id last_update_login
1100: FROM ar_vat_tax_all_b codes,
1101: ar_system_parameters_all asp,

Line 1099: fnd_global.conc_login_id last_update_login

1095: fnd_global.user_id created_by,
1096: sysdate creation_date,
1097: fnd_global.user_id last_updated_by,
1098: sysdate last_updated_date,
1099: fnd_global.conc_login_id last_update_login
1100: FROM ar_vat_tax_all_b codes,
1101: ar_system_parameters_all asp,
1102: zx_tax_priorities_t zxpt
1103:

Line 1211: fnd_global.user_id created_by,

1207: 'STANDARD') tax_status_code,
1208: 'STANDARD' recovery_type_code,
1209: 'N' frozen,
1210: zx_migrate_util.get_country(ap_codes.org_id) country_code,
1211: fnd_global.user_id created_by,
1212: sysdate creation_date,
1213: fnd_global.user_id last_updated_by,
1214: sysdate last_updated_date,
1215: fnd_global.conc_login_id last_update_login,

Line 1213: fnd_global.user_id last_updated_by,

1209: 'N' frozen,
1210: zx_migrate_util.get_country(ap_codes.org_id) country_code,
1211: fnd_global.user_id created_by,
1212: sysdate creation_date,
1213: fnd_global.user_id last_updated_by,
1214: sysdate last_updated_date,
1215: fnd_global.conc_login_id last_update_login,
1216: ap_codes.start_date effective_from,
1217: ap_codes.inactive_date effective_to,

Line 1215: fnd_global.conc_login_id last_update_login,

1211: fnd_global.user_id created_by,
1212: sysdate creation_date,
1213: fnd_global.user_id last_updated_by,
1214: sysdate last_updated_date,
1215: fnd_global.conc_login_id last_update_login,
1216: ap_codes.start_date effective_from,
1217: ap_codes.inactive_date effective_to,
1218: 'Y' intercompany_flag
1219: FROM ap_tax_codes_all ap_codes,

Line 1332: fnd_global.user_id created_by,

1328: 'STANDARD')) tax_status_code,
1329: NULL recovery_type_code,
1330: 'N' frozen,
1331: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,
1332: fnd_global.user_id created_by,
1333: sysdate creation_date,
1334: fnd_global.user_id last_updated_by,
1335: sysdate last_updated_date,
1336: fnd_global.conc_login_id last_update_login,

Line 1334: fnd_global.user_id last_updated_by,

1330: 'N' frozen,
1331: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,
1332: fnd_global.user_id created_by,
1333: sysdate creation_date,
1334: fnd_global.user_id last_updated_by,
1335: sysdate last_updated_date,
1336: fnd_global.conc_login_id last_update_login,
1337: ar_codes.start_date effective_from,
1338: ar_codes.end_date effective_to,

Line 1336: fnd_global.conc_login_id last_update_login,

1332: fnd_global.user_id created_by,
1333: sysdate creation_date,
1334: fnd_global.user_id last_updated_by,
1335: sysdate last_updated_date,
1336: fnd_global.conc_login_id last_update_login,
1337: ar_codes.start_date effective_from,
1338: ar_codes.end_date effective_to,
1339: 'Y' intercompany_flag
1340: FROM ar_vat_tax_all_b ar_codes,

Line 1616: fnd_global.user_id ,

1612: NULL ,--THRSHLD_CHK_TMPLT_CODE
1613: NULL ,--PERIOD_SET_NAME
1614: NULL ,--REP_TAX_AUTHORITY_ID
1615: NULL ,--COLL_TAX_AUTHORITY_ID
1616: fnd_global.user_id ,
1617: SYSDATE ,
1618: fnd_global.user_id ,
1619: SYSDATE ,
1620: fnd_global.conc_login_id ,

Line 1618: fnd_global.user_id ,

1614: NULL ,--REP_TAX_AUTHORITY_ID
1615: NULL ,--COLL_TAX_AUTHORITY_ID
1616: fnd_global.user_id ,
1617: SYSDATE ,
1618: fnd_global.user_id ,
1619: SYSDATE ,
1620: fnd_global.conc_login_id ,
1621: fnd_global.conc_request_id ,--Request Id
1622: fnd_global.prog_appl_id ,--Program Application ID

Line 1620: fnd_global.conc_login_id ,

1616: fnd_global.user_id ,
1617: SYSDATE ,
1618: fnd_global.user_id ,
1619: SYSDATE ,
1620: fnd_global.conc_login_id ,
1621: fnd_global.conc_request_id ,--Request Id
1622: fnd_global.prog_appl_id ,--Program Application ID
1623: fnd_global.conc_program_id ,--Program Id
1624: fnd_global.conc_login_id ,--Program Login ID

Line 1621: fnd_global.conc_request_id ,--Request Id

1617: SYSDATE ,
1618: fnd_global.user_id ,
1619: SYSDATE ,
1620: fnd_global.conc_login_id ,
1621: fnd_global.conc_request_id ,--Request Id
1622: fnd_global.prog_appl_id ,--Program Application ID
1623: fnd_global.conc_program_id ,--Program Id
1624: fnd_global.conc_login_id ,--Program Login ID
1625: 1

Line 1622: fnd_global.prog_appl_id ,--Program Application ID

1618: fnd_global.user_id ,
1619: SYSDATE ,
1620: fnd_global.conc_login_id ,
1621: fnd_global.conc_request_id ,--Request Id
1622: fnd_global.prog_appl_id ,--Program Application ID
1623: fnd_global.conc_program_id ,--Program Id
1624: fnd_global.conc_login_id ,--Program Login ID
1625: 1
1626: FROM

Line 1623: fnd_global.conc_program_id ,--Program Id

1619: SYSDATE ,
1620: fnd_global.conc_login_id ,
1621: fnd_global.conc_request_id ,--Request Id
1622: fnd_global.prog_appl_id ,--Program Application ID
1623: fnd_global.conc_program_id ,--Program Id
1624: fnd_global.conc_login_id ,--Program Login ID
1625: 1
1626: FROM
1627: (

Line 1624: fnd_global.conc_login_id ,--Program Login ID

1620: fnd_global.conc_login_id ,
1621: fnd_global.conc_request_id ,--Request Id
1622: fnd_global.prog_appl_id ,--Program Application ID
1623: fnd_global.conc_program_id ,--Program Id
1624: fnd_global.conc_login_id ,--Program Login ID
1625: 1
1626: FROM
1627: (
1628: SELECT DISTINCT

Line 1797: fnd_global.user_id ,

1793: NULL ,--THRSHLD_CHK_TMPLT_CODE
1794: NULL ,--PERIOD_SET_NAME
1795: NULL ,--REP_TAX_AUTHORITY_ID
1796: NULL ,--COLL_TAX_AUTHORITY_ID
1797: fnd_global.user_id ,
1798: SYSDATE ,
1799: fnd_global.user_id ,
1800: SYSDATE ,
1801: fnd_global.conc_login_id ,

Line 1799: fnd_global.user_id ,

1795: NULL ,--REP_TAX_AUTHORITY_ID
1796: NULL ,--COLL_TAX_AUTHORITY_ID
1797: fnd_global.user_id ,
1798: SYSDATE ,
1799: fnd_global.user_id ,
1800: SYSDATE ,
1801: fnd_global.conc_login_id ,
1802: fnd_global.conc_request_id ,--Request Id
1803: fnd_global.prog_appl_id ,--Program Application ID

Line 1801: fnd_global.conc_login_id ,

1797: fnd_global.user_id ,
1798: SYSDATE ,
1799: fnd_global.user_id ,
1800: SYSDATE ,
1801: fnd_global.conc_login_id ,
1802: fnd_global.conc_request_id ,--Request Id
1803: fnd_global.prog_appl_id ,--Program Application ID
1804: fnd_global.conc_program_id ,--Program Id
1805: fnd_global.conc_login_id ,--Program Login ID

Line 1802: fnd_global.conc_request_id ,--Request Id

1798: SYSDATE ,
1799: fnd_global.user_id ,
1800: SYSDATE ,
1801: fnd_global.conc_login_id ,
1802: fnd_global.conc_request_id ,--Request Id
1803: fnd_global.prog_appl_id ,--Program Application ID
1804: fnd_global.conc_program_id ,--Program Id
1805: fnd_global.conc_login_id ,--Program Login ID
1806: 1

Line 1803: fnd_global.prog_appl_id ,--Program Application ID

1799: fnd_global.user_id ,
1800: SYSDATE ,
1801: fnd_global.conc_login_id ,
1802: fnd_global.conc_request_id ,--Request Id
1803: fnd_global.prog_appl_id ,--Program Application ID
1804: fnd_global.conc_program_id ,--Program Id
1805: fnd_global.conc_login_id ,--Program Login ID
1806: 1
1807: FROM zx_regimes_b

Line 1804: fnd_global.conc_program_id ,--Program Id

1800: SYSDATE ,
1801: fnd_global.conc_login_id ,
1802: fnd_global.conc_request_id ,--Request Id
1803: fnd_global.prog_appl_id ,--Program Application ID
1804: fnd_global.conc_program_id ,--Program Id
1805: fnd_global.conc_login_id ,--Program Login ID
1806: 1
1807: FROM zx_regimes_b
1808: WHERE tax_regime_code = 'BR-ICMS'

Line 1805: fnd_global.conc_login_id ,--Program Login ID

1801: fnd_global.conc_login_id ,
1802: fnd_global.conc_request_id ,--Request Id
1803: fnd_global.prog_appl_id ,--Program Application ID
1804: fnd_global.conc_program_id ,--Program Id
1805: fnd_global.conc_login_id ,--Program Login ID
1806: 1
1807: FROM zx_regimes_b
1808: WHERE tax_regime_code = 'BR-ICMS'
1809: AND country_code = 'BR'

Line 1969: fnd_global.user_id ,

1965: NULL ,--THRSHLD_CHK_TMPLT_CODE
1966: NULL ,--PERIOD_SET_NAME
1967: NULL ,--REP_TAX_AUTHORITY_ID
1968: NULL ,--COLL_TAX_AUTHORITY_ID
1969: fnd_global.user_id ,
1970: SYSDATE ,
1971: fnd_global.user_id ,
1972: SYSDATE ,
1973: fnd_global.conc_login_id ,

Line 1971: fnd_global.user_id ,

1967: NULL ,--REP_TAX_AUTHORITY_ID
1968: NULL ,--COLL_TAX_AUTHORITY_ID
1969: fnd_global.user_id ,
1970: SYSDATE ,
1971: fnd_global.user_id ,
1972: SYSDATE ,
1973: fnd_global.conc_login_id ,
1974: fnd_global.conc_request_id ,--Request Id
1975: fnd_global.prog_appl_id ,--Program Application ID

Line 1973: fnd_global.conc_login_id ,

1969: fnd_global.user_id ,
1970: SYSDATE ,
1971: fnd_global.user_id ,
1972: SYSDATE ,
1973: fnd_global.conc_login_id ,
1974: fnd_global.conc_request_id ,--Request Id
1975: fnd_global.prog_appl_id ,--Program Application ID
1976: fnd_global.conc_program_id ,--Program Id
1977: fnd_global.conc_login_id ,--Program Login ID

Line 1974: fnd_global.conc_request_id ,--Request Id

1970: SYSDATE ,
1971: fnd_global.user_id ,
1972: SYSDATE ,
1973: fnd_global.conc_login_id ,
1974: fnd_global.conc_request_id ,--Request Id
1975: fnd_global.prog_appl_id ,--Program Application ID
1976: fnd_global.conc_program_id ,--Program Id
1977: fnd_global.conc_login_id ,--Program Login ID
1978: 1

Line 1975: fnd_global.prog_appl_id ,--Program Application ID

1971: fnd_global.user_id ,
1972: SYSDATE ,
1973: fnd_global.conc_login_id ,
1974: fnd_global.conc_request_id ,--Request Id
1975: fnd_global.prog_appl_id ,--Program Application ID
1976: fnd_global.conc_program_id ,--Program Id
1977: fnd_global.conc_login_id ,--Program Login ID
1978: 1
1979: FROM zx_regimes_b

Line 1976: fnd_global.conc_program_id ,--Program Id

1972: SYSDATE ,
1973: fnd_global.conc_login_id ,
1974: fnd_global.conc_request_id ,--Request Id
1975: fnd_global.prog_appl_id ,--Program Application ID
1976: fnd_global.conc_program_id ,--Program Id
1977: fnd_global.conc_login_id ,--Program Login ID
1978: 1
1979: FROM zx_regimes_b
1980: WHERE tax_regime_code = 'BR-IPI'

Line 1977: fnd_global.conc_login_id ,--Program Login ID

1973: fnd_global.conc_login_id ,
1974: fnd_global.conc_request_id ,--Request Id
1975: fnd_global.prog_appl_id ,--Program Application ID
1976: fnd_global.conc_program_id ,--Program Id
1977: fnd_global.conc_login_id ,--Program Login ID
1978: 1
1979: FROM zx_regimes_b
1980: WHERE tax_regime_code = 'BR-IPI'
1981: AND country_code = 'BR'

Line 2317: fnd_global.user_id ,

2313: NULL ,--THRSHLD_CHK_TMPLT_CODE
2314: NULL ,--PERIOD_SET_NAME
2315: NULL ,--REP_TAX_AUTHORITY_ID
2316: NULL ,--COLL_TAX_AUTHORITY_ID
2317: fnd_global.user_id ,
2318: SYSDATE ,
2319: fnd_global.user_id ,
2320: SYSDATE ,
2321: fnd_global.conc_login_id ,

Line 2319: fnd_global.user_id ,

2315: NULL ,--REP_TAX_AUTHORITY_ID
2316: NULL ,--COLL_TAX_AUTHORITY_ID
2317: fnd_global.user_id ,
2318: SYSDATE ,
2319: fnd_global.user_id ,
2320: SYSDATE ,
2321: fnd_global.conc_login_id ,
2322: fnd_global.conc_request_id ,--Request Id
2323: fnd_global.prog_appl_id ,--Program Application ID

Line 2321: fnd_global.conc_login_id ,

2317: fnd_global.user_id ,
2318: SYSDATE ,
2319: fnd_global.user_id ,
2320: SYSDATE ,
2321: fnd_global.conc_login_id ,
2322: fnd_global.conc_request_id ,--Request Id
2323: fnd_global.prog_appl_id ,--Program Application ID
2324: fnd_global.conc_program_id ,--Program Id
2325: fnd_global.conc_login_id ,--Program Login ID

Line 2322: fnd_global.conc_request_id ,--Request Id

2318: SYSDATE ,
2319: fnd_global.user_id ,
2320: SYSDATE ,
2321: fnd_global.conc_login_id ,
2322: fnd_global.conc_request_id ,--Request Id
2323: fnd_global.prog_appl_id ,--Program Application ID
2324: fnd_global.conc_program_id ,--Program Id
2325: fnd_global.conc_login_id ,--Program Login ID
2326: 1

Line 2323: fnd_global.prog_appl_id ,--Program Application ID

2319: fnd_global.user_id ,
2320: SYSDATE ,
2321: fnd_global.conc_login_id ,
2322: fnd_global.conc_request_id ,--Request Id
2323: fnd_global.prog_appl_id ,--Program Application ID
2324: fnd_global.conc_program_id ,--Program Id
2325: fnd_global.conc_login_id ,--Program Login ID
2326: 1
2327: )

Line 2324: fnd_global.conc_program_id ,--Program Id

2320: SYSDATE ,
2321: fnd_global.conc_login_id ,
2322: fnd_global.conc_request_id ,--Request Id
2323: fnd_global.prog_appl_id ,--Program Application ID
2324: fnd_global.conc_program_id ,--Program Id
2325: fnd_global.conc_login_id ,--Program Login ID
2326: 1
2327: )
2328: WHEN (NOT EXISTS (SELECT 1

Line 2325: fnd_global.conc_login_id ,--Program Login ID

2321: fnd_global.conc_login_id ,
2322: fnd_global.conc_request_id ,--Request Id
2323: fnd_global.prog_appl_id ,--Program Application ID
2324: fnd_global.conc_program_id ,--Program Id
2325: fnd_global.conc_login_id ,--Program Login ID
2326: 1
2327: )
2328: WHEN (NOT EXISTS (SELECT 1
2329: FROM ZX_REGIMES_B

Line 2358: fnd_global.user_id ,

2354: ELSE
2355: l_tax_regime_name
2356: END,
2357: SYSDATE,
2358: fnd_global.user_id ,
2359: SYSDATE ,
2360: fnd_global.user_id ,
2361: fnd_global.conc_login_id ,
2362: ZX_REGIMES_B_S.NEXTVAL

Line 2360: fnd_global.user_id ,

2356: END,
2357: SYSDATE,
2358: fnd_global.user_id ,
2359: SYSDATE ,
2360: fnd_global.user_id ,
2361: fnd_global.conc_login_id ,
2362: ZX_REGIMES_B_S.NEXTVAL
2363: )
2364: SELECT 1 FROM DUAL;

Line 2361: fnd_global.conc_login_id ,

2357: SYSDATE,
2358: fnd_global.user_id ,
2359: SYSDATE ,
2360: fnd_global.user_id ,
2361: fnd_global.conc_login_id ,
2362: ZX_REGIMES_B_S.NEXTVAL
2363: )
2364: SELECT 1 FROM DUAL;
2365: END IF;

Line 2527: fnd_global.user_id ,

2523: NULL ,--THRSHLD_CHK_TMPLT_CODE
2524: NULL ,--PERIOD_SET_NAME
2525: NULL ,--REP_TAX_AUTHORITY_ID
2526: NULL ,--COLL_TAX_AUTHORITY_ID
2527: fnd_global.user_id ,
2528: SYSDATE ,
2529: fnd_global.user_id ,
2530: SYSDATE ,
2531: fnd_global.conc_login_id ,

Line 2529: fnd_global.user_id ,

2525: NULL ,--REP_TAX_AUTHORITY_ID
2526: NULL ,--COLL_TAX_AUTHORITY_ID
2527: fnd_global.user_id ,
2528: SYSDATE ,
2529: fnd_global.user_id ,
2530: SYSDATE ,
2531: fnd_global.conc_login_id ,
2532: fnd_global.conc_request_id ,--Request Id
2533: fnd_global.prog_appl_id ,--Program Application ID

Line 2531: fnd_global.conc_login_id ,

2527: fnd_global.user_id ,
2528: SYSDATE ,
2529: fnd_global.user_id ,
2530: SYSDATE ,
2531: fnd_global.conc_login_id ,
2532: fnd_global.conc_request_id ,--Request Id
2533: fnd_global.prog_appl_id ,--Program Application ID
2534: fnd_global.conc_program_id ,--Program Id
2535: fnd_global.conc_login_id ,--Program Login ID

Line 2532: fnd_global.conc_request_id ,--Request Id

2528: SYSDATE ,
2529: fnd_global.user_id ,
2530: SYSDATE ,
2531: fnd_global.conc_login_id ,
2532: fnd_global.conc_request_id ,--Request Id
2533: fnd_global.prog_appl_id ,--Program Application ID
2534: fnd_global.conc_program_id ,--Program Id
2535: fnd_global.conc_login_id ,--Program Login ID
2536: 1

Line 2533: fnd_global.prog_appl_id ,--Program Application ID

2529: fnd_global.user_id ,
2530: SYSDATE ,
2531: fnd_global.conc_login_id ,
2532: fnd_global.conc_request_id ,--Request Id
2533: fnd_global.prog_appl_id ,--Program Application ID
2534: fnd_global.conc_program_id ,--Program Id
2535: fnd_global.conc_login_id ,--Program Login ID
2536: 1
2537: )

Line 2534: fnd_global.conc_program_id ,--Program Id

2530: SYSDATE ,
2531: fnd_global.conc_login_id ,
2532: fnd_global.conc_request_id ,--Request Id
2533: fnd_global.prog_appl_id ,--Program Application ID
2534: fnd_global.conc_program_id ,--Program Id
2535: fnd_global.conc_login_id ,--Program Login ID
2536: 1
2537: )
2538: SELECT distinct

Line 2535: fnd_global.conc_login_id ,--Program Login ID

2531: fnd_global.conc_login_id ,
2532: fnd_global.conc_request_id ,--Request Id
2533: fnd_global.prog_appl_id ,--Program Application ID
2534: fnd_global.conc_program_id ,--Program Id
2535: fnd_global.conc_login_id ,--Program Login ID
2536: 1
2537: )
2538: SELECT distinct
2539: CASE

Line 2607: fnd_global.user_id ,

2603: 'JL.CO.ARXSYSPA.SYS_PARAMETERS', d.meaning,
2604: B.TAX_REGIME_CODE)
2605: END ,
2606: SYSDATE ,
2607: fnd_global.user_id ,
2608: SYSDATE ,
2609: fnd_global.user_id ,
2610: fnd_global.conc_login_id ,
2611: B.TAX_REGIME_ID

Line 2609: fnd_global.user_id ,

2605: END ,
2606: SYSDATE ,
2607: fnd_global.user_id ,
2608: SYSDATE ,
2609: fnd_global.user_id ,
2610: fnd_global.conc_login_id ,
2611: B.TAX_REGIME_ID
2612: FROM
2613: FND_LANGUAGES L,

Line 2610: fnd_global.conc_login_id ,

2606: SYSDATE ,
2607: fnd_global.user_id ,
2608: SYSDATE ,
2609: fnd_global.user_id ,
2610: fnd_global.conc_login_id ,
2611: B.TAX_REGIME_ID
2612: FROM
2613: FND_LANGUAGES L,
2614: ZX_REGIMES_B B,

Line 2687: fnd_global.user_id ,

2683: 'JL.CO.ARXSYSPA.SYS_PARAMETERS', d.meaning,
2684: B.TAX_REGIME_CODE)
2685: end ,
2686: SYSDATE ,
2687: fnd_global.user_id ,
2688: SYSDATE ,
2689: fnd_global.user_id ,
2690: fnd_global.conc_login_id ,
2691: B.TAX_REGIME_ID

Line 2689: fnd_global.user_id ,

2685: end ,
2686: SYSDATE ,
2687: fnd_global.user_id ,
2688: SYSDATE ,
2689: fnd_global.user_id ,
2690: fnd_global.conc_login_id ,
2691: B.TAX_REGIME_ID
2692: FROM
2693: FND_LANGUAGES L,

Line 2690: fnd_global.conc_login_id ,

2686: SYSDATE ,
2687: fnd_global.user_id ,
2688: SYSDATE ,
2689: fnd_global.user_id ,
2690: fnd_global.conc_login_id ,
2691: B.TAX_REGIME_ID
2692: FROM
2693: FND_LANGUAGES L,
2694: ZX_REGIMES_B B,