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 936: fnd_global.user_id created_by,

932: 'N' frozen,
933: zx_migrate_util.get_country(codes.org_id) country_code,
934: codes.start_date effective_from,
935: codes.end_date effective_to,
936: fnd_global.user_id created_by,
937: sysdate creation_date,
938: fnd_global.user_id last_updated_by,
939: sysdate last_updated_date,
940: fnd_global.conc_login_id last_update_login

Line 938: fnd_global.user_id last_updated_by,

934: codes.start_date effective_from,
935: codes.end_date effective_to,
936: fnd_global.user_id created_by,
937: sysdate creation_date,
938: fnd_global.user_id last_updated_by,
939: sysdate last_updated_date,
940: fnd_global.conc_login_id last_update_login
941: FROM ar_vat_tax_all_b codes,
942: ar_system_parameters_all asp,

Line 940: fnd_global.conc_login_id last_update_login

936: fnd_global.user_id created_by,
937: sysdate creation_date,
938: fnd_global.user_id last_updated_by,
939: sysdate last_updated_date,
940: fnd_global.conc_login_id last_update_login
941: FROM ar_vat_tax_all_b codes,
942: ar_system_parameters_all asp,
943: zx_tax_priorities_t zxpt
944:

Line 1018: fnd_global.user_id created_by,

1014: 'N' frozen,
1015: zx_migrate_util.get_country(codes.org_id) country_code,
1016: codes.start_date effective_from,
1017: codes.end_date effective_to,
1018: fnd_global.user_id created_by,
1019: sysdate creation_date,
1020: fnd_global.user_id last_updated_by,
1021: sysdate last_updated_date,
1022: fnd_global.conc_login_id last_update_login

Line 1020: fnd_global.user_id last_updated_by,

1016: codes.start_date effective_from,
1017: codes.end_date effective_to,
1018: fnd_global.user_id created_by,
1019: sysdate creation_date,
1020: fnd_global.user_id last_updated_by,
1021: sysdate last_updated_date,
1022: fnd_global.conc_login_id last_update_login
1023: FROM ar_vat_tax_all_b codes,
1024: ar_system_parameters_all asp,

Line 1022: fnd_global.conc_login_id last_update_login

1018: fnd_global.user_id created_by,
1019: sysdate creation_date,
1020: fnd_global.user_id last_updated_by,
1021: sysdate last_updated_date,
1022: fnd_global.conc_login_id last_update_login
1023: FROM ar_vat_tax_all_b codes,
1024: ar_system_parameters_all asp,
1025: zx_tax_priorities_t zxpt
1026:

Line 1134: fnd_global.user_id created_by,

1130: 'STANDARD') tax_status_code,
1131: 'STANDARD' recovery_type_code,
1132: 'N' frozen,
1133: zx_migrate_util.get_country(ap_codes.org_id) country_code,
1134: fnd_global.user_id created_by,
1135: sysdate creation_date,
1136: fnd_global.user_id last_updated_by,
1137: sysdate last_updated_date,
1138: fnd_global.conc_login_id last_update_login,

Line 1136: fnd_global.user_id last_updated_by,

1132: 'N' frozen,
1133: zx_migrate_util.get_country(ap_codes.org_id) country_code,
1134: fnd_global.user_id created_by,
1135: sysdate creation_date,
1136: fnd_global.user_id last_updated_by,
1137: sysdate last_updated_date,
1138: fnd_global.conc_login_id last_update_login,
1139: ap_codes.start_date effective_from,
1140: ap_codes.inactive_date effective_to,

Line 1138: fnd_global.conc_login_id last_update_login,

1134: fnd_global.user_id created_by,
1135: sysdate creation_date,
1136: fnd_global.user_id last_updated_by,
1137: sysdate last_updated_date,
1138: fnd_global.conc_login_id last_update_login,
1139: ap_codes.start_date effective_from,
1140: ap_codes.inactive_date effective_to,
1141: 'Y' intercompany_flag
1142: FROM ap_tax_codes_all ap_codes,

Line 1255: fnd_global.user_id created_by,

1251: 'STANDARD')) tax_status_code,
1252: NULL recovery_type_code,
1253: 'N' frozen,
1254: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,
1255: fnd_global.user_id created_by,
1256: sysdate creation_date,
1257: fnd_global.user_id last_updated_by,
1258: sysdate last_updated_date,
1259: fnd_global.conc_login_id last_update_login,

Line 1257: fnd_global.user_id last_updated_by,

1253: 'N' frozen,
1254: zx_migrate_util.get_country(decode(l_multi_org_flag,'N',l_org_id,ar_codes.org_id)) country_code,
1255: fnd_global.user_id created_by,
1256: sysdate creation_date,
1257: fnd_global.user_id last_updated_by,
1258: sysdate last_updated_date,
1259: fnd_global.conc_login_id last_update_login,
1260: ar_codes.start_date effective_from,
1261: ar_codes.end_date effective_to,

Line 1259: fnd_global.conc_login_id last_update_login,

1255: fnd_global.user_id created_by,
1256: sysdate creation_date,
1257: fnd_global.user_id last_updated_by,
1258: sysdate last_updated_date,
1259: fnd_global.conc_login_id last_update_login,
1260: ar_codes.start_date effective_from,
1261: ar_codes.end_date effective_to,
1262: 'Y' intercompany_flag
1263: FROM ar_vat_tax_all_b ar_codes,

Line 1539: fnd_global.user_id ,

1535: NULL ,--THRSHLD_CHK_TMPLT_CODE
1536: NULL ,--PERIOD_SET_NAME
1537: NULL ,--REP_TAX_AUTHORITY_ID
1538: NULL ,--COLL_TAX_AUTHORITY_ID
1539: fnd_global.user_id ,
1540: SYSDATE ,
1541: fnd_global.user_id ,
1542: SYSDATE ,
1543: fnd_global.conc_login_id ,

Line 1541: fnd_global.user_id ,

1537: NULL ,--REP_TAX_AUTHORITY_ID
1538: NULL ,--COLL_TAX_AUTHORITY_ID
1539: fnd_global.user_id ,
1540: SYSDATE ,
1541: fnd_global.user_id ,
1542: SYSDATE ,
1543: fnd_global.conc_login_id ,
1544: fnd_global.conc_request_id ,--Request Id
1545: fnd_global.prog_appl_id ,--Program Application ID

Line 1543: fnd_global.conc_login_id ,

1539: fnd_global.user_id ,
1540: SYSDATE ,
1541: fnd_global.user_id ,
1542: SYSDATE ,
1543: fnd_global.conc_login_id ,
1544: fnd_global.conc_request_id ,--Request Id
1545: fnd_global.prog_appl_id ,--Program Application ID
1546: fnd_global.conc_program_id ,--Program Id
1547: fnd_global.conc_login_id ,--Program Login ID

Line 1544: fnd_global.conc_request_id ,--Request Id

1540: SYSDATE ,
1541: fnd_global.user_id ,
1542: SYSDATE ,
1543: fnd_global.conc_login_id ,
1544: fnd_global.conc_request_id ,--Request Id
1545: fnd_global.prog_appl_id ,--Program Application ID
1546: fnd_global.conc_program_id ,--Program Id
1547: fnd_global.conc_login_id ,--Program Login ID
1548: 1

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

1541: fnd_global.user_id ,
1542: SYSDATE ,
1543: fnd_global.conc_login_id ,
1544: fnd_global.conc_request_id ,--Request Id
1545: fnd_global.prog_appl_id ,--Program Application ID
1546: fnd_global.conc_program_id ,--Program Id
1547: fnd_global.conc_login_id ,--Program Login ID
1548: 1
1549: FROM

Line 1546: fnd_global.conc_program_id ,--Program Id

1542: SYSDATE ,
1543: fnd_global.conc_login_id ,
1544: fnd_global.conc_request_id ,--Request Id
1545: fnd_global.prog_appl_id ,--Program Application ID
1546: fnd_global.conc_program_id ,--Program Id
1547: fnd_global.conc_login_id ,--Program Login ID
1548: 1
1549: FROM
1550: (

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

1543: fnd_global.conc_login_id ,
1544: fnd_global.conc_request_id ,--Request Id
1545: fnd_global.prog_appl_id ,--Program Application ID
1546: fnd_global.conc_program_id ,--Program Id
1547: fnd_global.conc_login_id ,--Program Login ID
1548: 1
1549: FROM
1550: (
1551: SELECT DISTINCT

Line 1720: fnd_global.user_id ,

1716: NULL ,--THRSHLD_CHK_TMPLT_CODE
1717: NULL ,--PERIOD_SET_NAME
1718: NULL ,--REP_TAX_AUTHORITY_ID
1719: NULL ,--COLL_TAX_AUTHORITY_ID
1720: fnd_global.user_id ,
1721: SYSDATE ,
1722: fnd_global.user_id ,
1723: SYSDATE ,
1724: fnd_global.conc_login_id ,

Line 1722: fnd_global.user_id ,

1718: NULL ,--REP_TAX_AUTHORITY_ID
1719: NULL ,--COLL_TAX_AUTHORITY_ID
1720: fnd_global.user_id ,
1721: SYSDATE ,
1722: fnd_global.user_id ,
1723: SYSDATE ,
1724: fnd_global.conc_login_id ,
1725: fnd_global.conc_request_id ,--Request Id
1726: fnd_global.prog_appl_id ,--Program Application ID

Line 1724: fnd_global.conc_login_id ,

1720: fnd_global.user_id ,
1721: SYSDATE ,
1722: fnd_global.user_id ,
1723: SYSDATE ,
1724: fnd_global.conc_login_id ,
1725: fnd_global.conc_request_id ,--Request Id
1726: fnd_global.prog_appl_id ,--Program Application ID
1727: fnd_global.conc_program_id ,--Program Id
1728: fnd_global.conc_login_id ,--Program Login ID

Line 1725: fnd_global.conc_request_id ,--Request Id

1721: SYSDATE ,
1722: fnd_global.user_id ,
1723: SYSDATE ,
1724: fnd_global.conc_login_id ,
1725: fnd_global.conc_request_id ,--Request Id
1726: fnd_global.prog_appl_id ,--Program Application ID
1727: fnd_global.conc_program_id ,--Program Id
1728: fnd_global.conc_login_id ,--Program Login ID
1729: 1

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

1722: fnd_global.user_id ,
1723: SYSDATE ,
1724: fnd_global.conc_login_id ,
1725: fnd_global.conc_request_id ,--Request Id
1726: fnd_global.prog_appl_id ,--Program Application ID
1727: fnd_global.conc_program_id ,--Program Id
1728: fnd_global.conc_login_id ,--Program Login ID
1729: 1
1730: FROM zx_regimes_b

Line 1727: fnd_global.conc_program_id ,--Program Id

1723: SYSDATE ,
1724: fnd_global.conc_login_id ,
1725: fnd_global.conc_request_id ,--Request Id
1726: fnd_global.prog_appl_id ,--Program Application ID
1727: fnd_global.conc_program_id ,--Program Id
1728: fnd_global.conc_login_id ,--Program Login ID
1729: 1
1730: FROM zx_regimes_b
1731: WHERE tax_regime_code = 'BR-ICMS'

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

1724: fnd_global.conc_login_id ,
1725: fnd_global.conc_request_id ,--Request Id
1726: fnd_global.prog_appl_id ,--Program Application ID
1727: fnd_global.conc_program_id ,--Program Id
1728: fnd_global.conc_login_id ,--Program Login ID
1729: 1
1730: FROM zx_regimes_b
1731: WHERE tax_regime_code = 'BR-ICMS'
1732: AND country_code = 'BR'

Line 1892: fnd_global.user_id ,

1888: NULL ,--THRSHLD_CHK_TMPLT_CODE
1889: NULL ,--PERIOD_SET_NAME
1890: NULL ,--REP_TAX_AUTHORITY_ID
1891: NULL ,--COLL_TAX_AUTHORITY_ID
1892: fnd_global.user_id ,
1893: SYSDATE ,
1894: fnd_global.user_id ,
1895: SYSDATE ,
1896: fnd_global.conc_login_id ,

Line 1894: fnd_global.user_id ,

1890: NULL ,--REP_TAX_AUTHORITY_ID
1891: NULL ,--COLL_TAX_AUTHORITY_ID
1892: fnd_global.user_id ,
1893: SYSDATE ,
1894: fnd_global.user_id ,
1895: SYSDATE ,
1896: fnd_global.conc_login_id ,
1897: fnd_global.conc_request_id ,--Request Id
1898: fnd_global.prog_appl_id ,--Program Application ID

Line 1896: fnd_global.conc_login_id ,

1892: fnd_global.user_id ,
1893: SYSDATE ,
1894: fnd_global.user_id ,
1895: SYSDATE ,
1896: fnd_global.conc_login_id ,
1897: fnd_global.conc_request_id ,--Request Id
1898: fnd_global.prog_appl_id ,--Program Application ID
1899: fnd_global.conc_program_id ,--Program Id
1900: fnd_global.conc_login_id ,--Program Login ID

Line 1897: fnd_global.conc_request_id ,--Request Id

1893: SYSDATE ,
1894: fnd_global.user_id ,
1895: SYSDATE ,
1896: fnd_global.conc_login_id ,
1897: fnd_global.conc_request_id ,--Request Id
1898: fnd_global.prog_appl_id ,--Program Application ID
1899: fnd_global.conc_program_id ,--Program Id
1900: fnd_global.conc_login_id ,--Program Login ID
1901: 1

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

1894: fnd_global.user_id ,
1895: SYSDATE ,
1896: fnd_global.conc_login_id ,
1897: fnd_global.conc_request_id ,--Request Id
1898: fnd_global.prog_appl_id ,--Program Application ID
1899: fnd_global.conc_program_id ,--Program Id
1900: fnd_global.conc_login_id ,--Program Login ID
1901: 1
1902: FROM zx_regimes_b

Line 1899: fnd_global.conc_program_id ,--Program Id

1895: SYSDATE ,
1896: fnd_global.conc_login_id ,
1897: fnd_global.conc_request_id ,--Request Id
1898: fnd_global.prog_appl_id ,--Program Application ID
1899: fnd_global.conc_program_id ,--Program Id
1900: fnd_global.conc_login_id ,--Program Login ID
1901: 1
1902: FROM zx_regimes_b
1903: WHERE tax_regime_code = 'BR-IPI'

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

1896: fnd_global.conc_login_id ,
1897: fnd_global.conc_request_id ,--Request Id
1898: fnd_global.prog_appl_id ,--Program Application ID
1899: fnd_global.conc_program_id ,--Program Id
1900: fnd_global.conc_login_id ,--Program Login ID
1901: 1
1902: FROM zx_regimes_b
1903: WHERE tax_regime_code = 'BR-IPI'
1904: AND country_code = 'BR'

Line 2240: fnd_global.user_id ,

2236: NULL ,--THRSHLD_CHK_TMPLT_CODE
2237: NULL ,--PERIOD_SET_NAME
2238: NULL ,--REP_TAX_AUTHORITY_ID
2239: NULL ,--COLL_TAX_AUTHORITY_ID
2240: fnd_global.user_id ,
2241: SYSDATE ,
2242: fnd_global.user_id ,
2243: SYSDATE ,
2244: fnd_global.conc_login_id ,

Line 2242: fnd_global.user_id ,

2238: NULL ,--REP_TAX_AUTHORITY_ID
2239: NULL ,--COLL_TAX_AUTHORITY_ID
2240: fnd_global.user_id ,
2241: SYSDATE ,
2242: fnd_global.user_id ,
2243: SYSDATE ,
2244: fnd_global.conc_login_id ,
2245: fnd_global.conc_request_id ,--Request Id
2246: fnd_global.prog_appl_id ,--Program Application ID

Line 2244: fnd_global.conc_login_id ,

2240: fnd_global.user_id ,
2241: SYSDATE ,
2242: fnd_global.user_id ,
2243: SYSDATE ,
2244: fnd_global.conc_login_id ,
2245: fnd_global.conc_request_id ,--Request Id
2246: fnd_global.prog_appl_id ,--Program Application ID
2247: fnd_global.conc_program_id ,--Program Id
2248: fnd_global.conc_login_id ,--Program Login ID

Line 2245: fnd_global.conc_request_id ,--Request Id

2241: SYSDATE ,
2242: fnd_global.user_id ,
2243: SYSDATE ,
2244: fnd_global.conc_login_id ,
2245: fnd_global.conc_request_id ,--Request Id
2246: fnd_global.prog_appl_id ,--Program Application ID
2247: fnd_global.conc_program_id ,--Program Id
2248: fnd_global.conc_login_id ,--Program Login ID
2249: 1

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

2242: fnd_global.user_id ,
2243: SYSDATE ,
2244: fnd_global.conc_login_id ,
2245: fnd_global.conc_request_id ,--Request Id
2246: fnd_global.prog_appl_id ,--Program Application ID
2247: fnd_global.conc_program_id ,--Program Id
2248: fnd_global.conc_login_id ,--Program Login ID
2249: 1
2250: )

Line 2247: fnd_global.conc_program_id ,--Program Id

2243: SYSDATE ,
2244: fnd_global.conc_login_id ,
2245: fnd_global.conc_request_id ,--Request Id
2246: fnd_global.prog_appl_id ,--Program Application ID
2247: fnd_global.conc_program_id ,--Program Id
2248: fnd_global.conc_login_id ,--Program Login ID
2249: 1
2250: )
2251: WHEN (NOT EXISTS (SELECT 1

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

2244: fnd_global.conc_login_id ,
2245: fnd_global.conc_request_id ,--Request Id
2246: fnd_global.prog_appl_id ,--Program Application ID
2247: fnd_global.conc_program_id ,--Program Id
2248: fnd_global.conc_login_id ,--Program Login ID
2249: 1
2250: )
2251: WHEN (NOT EXISTS (SELECT 1
2252: FROM ZX_REGIMES_B

Line 2281: fnd_global.user_id ,

2277: ELSE
2278: l_tax_regime_name
2279: END,
2280: SYSDATE,
2281: fnd_global.user_id ,
2282: SYSDATE ,
2283: fnd_global.user_id ,
2284: fnd_global.conc_login_id ,
2285: ZX_REGIMES_B_S.NEXTVAL

Line 2283: fnd_global.user_id ,

2279: END,
2280: SYSDATE,
2281: fnd_global.user_id ,
2282: SYSDATE ,
2283: fnd_global.user_id ,
2284: fnd_global.conc_login_id ,
2285: ZX_REGIMES_B_S.NEXTVAL
2286: )
2287: SELECT 1 FROM DUAL;

Line 2284: fnd_global.conc_login_id ,

2280: SYSDATE,
2281: fnd_global.user_id ,
2282: SYSDATE ,
2283: fnd_global.user_id ,
2284: fnd_global.conc_login_id ,
2285: ZX_REGIMES_B_S.NEXTVAL
2286: )
2287: SELECT 1 FROM DUAL;
2288: END IF;

Line 2450: fnd_global.user_id ,

2446: NULL ,--THRSHLD_CHK_TMPLT_CODE
2447: NULL ,--PERIOD_SET_NAME
2448: NULL ,--REP_TAX_AUTHORITY_ID
2449: NULL ,--COLL_TAX_AUTHORITY_ID
2450: fnd_global.user_id ,
2451: SYSDATE ,
2452: fnd_global.user_id ,
2453: SYSDATE ,
2454: fnd_global.conc_login_id ,

Line 2452: fnd_global.user_id ,

2448: NULL ,--REP_TAX_AUTHORITY_ID
2449: NULL ,--COLL_TAX_AUTHORITY_ID
2450: fnd_global.user_id ,
2451: SYSDATE ,
2452: fnd_global.user_id ,
2453: SYSDATE ,
2454: fnd_global.conc_login_id ,
2455: fnd_global.conc_request_id ,--Request Id
2456: fnd_global.prog_appl_id ,--Program Application ID

Line 2454: fnd_global.conc_login_id ,

2450: fnd_global.user_id ,
2451: SYSDATE ,
2452: fnd_global.user_id ,
2453: SYSDATE ,
2454: fnd_global.conc_login_id ,
2455: fnd_global.conc_request_id ,--Request Id
2456: fnd_global.prog_appl_id ,--Program Application ID
2457: fnd_global.conc_program_id ,--Program Id
2458: fnd_global.conc_login_id ,--Program Login ID

Line 2455: fnd_global.conc_request_id ,--Request Id

2451: SYSDATE ,
2452: fnd_global.user_id ,
2453: SYSDATE ,
2454: fnd_global.conc_login_id ,
2455: fnd_global.conc_request_id ,--Request Id
2456: fnd_global.prog_appl_id ,--Program Application ID
2457: fnd_global.conc_program_id ,--Program Id
2458: fnd_global.conc_login_id ,--Program Login ID
2459: 1

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

2452: fnd_global.user_id ,
2453: SYSDATE ,
2454: fnd_global.conc_login_id ,
2455: fnd_global.conc_request_id ,--Request Id
2456: fnd_global.prog_appl_id ,--Program Application ID
2457: fnd_global.conc_program_id ,--Program Id
2458: fnd_global.conc_login_id ,--Program Login ID
2459: 1
2460: )

Line 2457: fnd_global.conc_program_id ,--Program Id

2453: SYSDATE ,
2454: fnd_global.conc_login_id ,
2455: fnd_global.conc_request_id ,--Request Id
2456: fnd_global.prog_appl_id ,--Program Application ID
2457: fnd_global.conc_program_id ,--Program Id
2458: fnd_global.conc_login_id ,--Program Login ID
2459: 1
2460: )
2461: SELECT distinct

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

2454: fnd_global.conc_login_id ,
2455: fnd_global.conc_request_id ,--Request Id
2456: fnd_global.prog_appl_id ,--Program Application ID
2457: fnd_global.conc_program_id ,--Program Id
2458: fnd_global.conc_login_id ,--Program Login ID
2459: 1
2460: )
2461: SELECT distinct
2462: CASE

Line 2530: fnd_global.user_id ,

2526: 'JL.CO.ARXSYSPA.SYS_PARAMETERS', d.meaning,
2527: B.TAX_REGIME_CODE)
2528: END ,
2529: SYSDATE ,
2530: fnd_global.user_id ,
2531: SYSDATE ,
2532: fnd_global.user_id ,
2533: fnd_global.conc_login_id ,
2534: B.TAX_REGIME_ID

Line 2532: fnd_global.user_id ,

2528: END ,
2529: SYSDATE ,
2530: fnd_global.user_id ,
2531: SYSDATE ,
2532: fnd_global.user_id ,
2533: fnd_global.conc_login_id ,
2534: B.TAX_REGIME_ID
2535: FROM
2536: FND_LANGUAGES L,

Line 2533: fnd_global.conc_login_id ,

2529: SYSDATE ,
2530: fnd_global.user_id ,
2531: SYSDATE ,
2532: fnd_global.user_id ,
2533: fnd_global.conc_login_id ,
2534: B.TAX_REGIME_ID
2535: FROM
2536: FND_LANGUAGES L,
2537: ZX_REGIMES_B B,

Line 2610: fnd_global.user_id ,

2606: 'JL.CO.ARXSYSPA.SYS_PARAMETERS', d.meaning,
2607: B.TAX_REGIME_CODE)
2608: end ,
2609: SYSDATE ,
2610: fnd_global.user_id ,
2611: SYSDATE ,
2612: fnd_global.user_id ,
2613: fnd_global.conc_login_id ,
2614: B.TAX_REGIME_ID

Line 2612: fnd_global.user_id ,

2608: end ,
2609: SYSDATE ,
2610: fnd_global.user_id ,
2611: SYSDATE ,
2612: fnd_global.user_id ,
2613: fnd_global.conc_login_id ,
2614: B.TAX_REGIME_ID
2615: FROM
2616: FND_LANGUAGES L,

Line 2613: fnd_global.conc_login_id ,

2609: SYSDATE ,
2610: fnd_global.user_id ,
2611: SYSDATE ,
2612: fnd_global.user_id ,
2613: fnd_global.conc_login_id ,
2614: B.TAX_REGIME_ID
2615: FROM
2616: FND_LANGUAGES L,
2617: ZX_REGIMES_B B,