DBA Data[Home] [Help]

APPS.ZX_UPGRADE_CONTROL_PKG dependencies on FND_GLOBAL

Line 368: ,fnd_global.user_id -- Who Columns

364: ,'MIGRATED' -- Record Type
365: ,p_vat_code -- Tax Classification
366: ,'N' -- Self_Assess_Flag
367: ,nvl(p_offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
368: ,fnd_global.user_id -- Who Columns
369: ,SYSDATE -- Who Columns
370: ,fnd_global.user_id -- Who Columns
371: ,SYSDATE -- Who Columns
372: ,FND_GLOBAL.CONC_LOGIN_ID); -- Who Columns

Line 370: ,fnd_global.user_id -- Who Columns

366: ,'N' -- Self_Assess_Flag
367: ,nvl(p_offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
368: ,fnd_global.user_id -- Who Columns
369: ,SYSDATE -- Who Columns
370: ,fnd_global.user_id -- Who Columns
371: ,SYSDATE -- Who Columns
372: ,FND_GLOBAL.CONC_LOGIN_ID); -- Who Columns
373:
374:

Line 372: ,FND_GLOBAL.CONC_LOGIN_ID); -- Who Columns

368: ,fnd_global.user_id -- Who Columns
369: ,SYSDATE -- Who Columns
370: ,fnd_global.user_id -- Who Columns
371: ,SYSDATE -- Who Columns
372: ,FND_GLOBAL.CONC_LOGIN_ID); -- Who Columns
373:
374:
375: INSERT INTO
376: ZX_REGISTRATIONS(

Line 434: ,fnd_global.user_id

430: ,NULL -- Rep_Party_Tax_Name
431: ,NULL -- Legal Registration_ID
432: ,'Y' -- Default Registration Flag
433: ,'MIGRATED' -- Record Type
434: ,fnd_global.user_id
435: ,SYSDATE
436: ,fnd_global.user_id
437: ,SYSDATE
438: ,FND_GLOBAL.CONC_LOGIN_ID

Line 436: ,fnd_global.user_id

432: ,'Y' -- Default Registration Flag
433: ,'MIGRATED' -- Record Type
434: ,fnd_global.user_id
435: ,SYSDATE
436: ,fnd_global.user_id
437: ,SYSDATE
438: ,FND_GLOBAL.CONC_LOGIN_ID
439: FROM zx_party_tax_profile ptp
440: WHERE PTP.Party_ID = P_VENDOR_ID

Line 438: ,FND_GLOBAL.CONC_LOGIN_ID

434: ,fnd_global.user_id
435: ,SYSDATE
436: ,fnd_global.user_id
437: ,SYSDATE
438: ,FND_GLOBAL.CONC_LOGIN_ID
439: FROM zx_party_tax_profile ptp
440: WHERE PTP.Party_ID = P_VENDOR_ID
441: AND PTP.Party_Type_code = 'SUPPLIER');
442:

Line 483: Last_updated_By=fnd_global.user_id,

479: TAX_CLASSIFICATION_CODE=
480: p_vat_code, -- Tax Classification
481: Allow_Offset_Tax_Flag=
482: nvl(p_Offset_Tax_Flag,'N'), -- Allow_Offset_Tax_Flag,
483: Last_updated_By=fnd_global.user_id,
484: Last_update_Date=SYSDATE,
485: Last_update_Login=FND_GLOBAL.CONC_LOGIN_ID
486: WHERE party_tax_profile_id=p_vendor_id and
487: party_type_code ='SUPPLIER';

Line 485: Last_update_Login=FND_GLOBAL.CONC_LOGIN_ID

481: Allow_Offset_Tax_Flag=
482: nvl(p_Offset_Tax_Flag,'N'), -- Allow_Offset_Tax_Flag,
483: Last_updated_By=fnd_global.user_id,
484: Last_update_Date=SYSDATE,
485: Last_update_Login=FND_GLOBAL.CONC_LOGIN_ID
486: WHERE party_tax_profile_id=p_vendor_id and
487: party_type_code ='SUPPLIER';
488:
489: UPDATE ZX_REGISTRATIONS

Line 502: Last_Updated_By = fnd_global.user_id,

498: ROUNDING_RULE_CODE = decode(nvl(p_auto_tax_calc_flag,'L'),'L','LINE','H','HEADER','T','HEADER','LINE'),
499: Inclusive_Tax_Flag = nvl(p_amount_includes_tax_flag,'N'),
500: Effective_From = nvl(p_start_date_active, Sysdate),
501: Effective_To = p_end_date_active,
502: Last_Updated_By = fnd_global.user_id,
503: Last_Update_Date = SYSDATE,
504: Last_Update_Login = FND_GLOBAL.CONC_LOGIN_ID
505: WHERE Party_tax_profile_id in (select party_tax_profile_id
506: from zx_party_tax_profile where party_id

Line 504: Last_Update_Login = FND_GLOBAL.CONC_LOGIN_ID

500: Effective_From = nvl(p_start_date_active, Sysdate),
501: Effective_To = p_end_date_active,
502: Last_Updated_By = fnd_global.user_id,
503: Last_Update_Date = SYSDATE,
504: Last_Update_Login = FND_GLOBAL.CONC_LOGIN_ID
505: WHERE Party_tax_profile_id in (select party_tax_profile_id
506: from zx_party_tax_profile where party_id
507: = p_vendor_id and party_type_code = 'SUPPLIER');
508:

Line 794: , fnd_global.user_id -- Who Columns

790: ,'MIGRATED' -- Record Type
791: ,p_vat_code -- Tax Classification
792: ,'N' -- Self_Assess_Flag
793: , nvl(pv.offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
794: , fnd_global.user_id -- Who Columns
795: ,SYSDATE -- Who Columns
796: ,fnd_global.user_id -- Who Columns
797: ,SYSDATE -- Who Columns
798: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

Line 796: ,fnd_global.user_id -- Who Columns

792: ,'N' -- Self_Assess_Flag
793: , nvl(pv.offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
794: , fnd_global.user_id -- Who Columns
795: ,SYSDATE -- Who Columns
796: ,fnd_global.user_id -- Who Columns
797: ,SYSDATE -- Who Columns
798: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
799: FROM ap_suppliers Pv
800: WHERE p_Vendor_Site_Id = nvl(P_vendor_site_Id,p_Vendor_site_Id)

Line 798: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

794: , fnd_global.user_id -- Who Columns
795: ,SYSDATE -- Who Columns
796: ,fnd_global.user_id -- Who Columns
797: ,SYSDATE -- Who Columns
798: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
799: FROM ap_suppliers Pv
800: WHERE p_Vendor_Site_Id = nvl(P_vendor_site_Id,p_Vendor_site_Id)
801: AND p_vendor_id = pv.vendor_id
802: AND pv.VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';

Line 856: ,fnd_global.user_id

852: ,NULL -- Rep_Party_Tax_Name
853: ,NULL -- Legal Registration_ID
854: ,'Y' -- Default Registration Flag
855: ,'MIGRATED' -- Record Type
856: ,fnd_global.user_id
857: ,SYSDATE
858: ,fnd_global.user_id
859: ,SYSDATE
860: ,FND_GLOBAL.CONC_LOGIN_ID

Line 858: ,fnd_global.user_id

854: ,'Y' -- Default Registration Flag
855: ,'MIGRATED' -- Record Type
856: ,fnd_global.user_id
857: ,SYSDATE
858: ,fnd_global.user_id
859: ,SYSDATE
860: ,FND_GLOBAL.CONC_LOGIN_ID
861: FROM ap_suppliers PV,
862: zx_party_tax_profile PTP

Line 860: ,FND_GLOBAL.CONC_LOGIN_ID

856: ,fnd_global.user_id
857: ,SYSDATE
858: ,fnd_global.user_id
859: ,SYSDATE
860: ,FND_GLOBAL.CONC_LOGIN_ID
861: FROM ap_suppliers PV,
862: zx_party_tax_profile PTP
863: WHERE
864: P_vendor_site_id = PTP.Party_ID

Line 898: fnd_global.user_id,

894: p_GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
895: null, --EXCEPTION_CODE
896: sysdate, --EFFECTIVE_FROM
897: null, --EFFECTIVE_TO
898: fnd_global.user_id,
899: sysdate,
900: fnd_global.user_id,
901: sysdate,
902: fnd_global.conc_login_id

Line 900: fnd_global.user_id,

896: sysdate, --EFFECTIVE_FROM
897: null, --EFFECTIVE_TO
898: fnd_global.user_id,
899: sysdate,
900: fnd_global.user_id,
901: sysdate,
902: fnd_global.conc_login_id
903: FROM zx_party_tax_profile ptp ,
904: zx_reporting_types_b

Line 902: fnd_global.conc_login_id

898: fnd_global.user_id,
899: sysdate,
900: fnd_global.user_id,
901: sysdate,
902: fnd_global.conc_login_id
903: FROM zx_party_tax_profile ptp ,
904: zx_reporting_types_b
905: WHERE ptp.party_id = p_vendor_site_id and
906: ptp.Party_Type_Code = 'SUPPLIER_SITE' and

Line 934: fnd_global.user_id,

930: p_GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
931: null, --EXCEPTION_CODE
932: sysdate, --EFFECTIVE_FROM
933: p_GLOBAL_ATTRIBUTE20, --EFFECTIVE_TO
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.user_id,
937: sysdate,
938: fnd_global.conc_login_id

Line 936: fnd_global.user_id,

932: sysdate, --EFFECTIVE_FROM
933: p_GLOBAL_ATTRIBUTE20, --EFFECTIVE_TO
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.user_id,
937: sysdate,
938: fnd_global.conc_login_id
939: FROM zx_party_tax_profile ptp ,
940: zx_reporting_types_b

Line 938: fnd_global.conc_login_id

934: fnd_global.user_id,
935: sysdate,
936: fnd_global.user_id,
937: sysdate,
938: fnd_global.conc_login_id
939: FROM zx_party_tax_profile ptp ,
940: zx_reporting_types_b
941: WHERE ptp.party_id = p_vendor_site_id and
942: ptp.Party_Type_Code = 'SUPPLIER_SITE' and

Line 1002: ,fnd_global.user_id

998: ,NULL -- Rep_Party_Tax_Name
999: ,NULL -- Legal Registration_ID
1000: ,'Y' -- Default Registration Flag
1001: ,'MIGRATED' -- Record Type
1002: ,fnd_global.user_id
1003: ,SYSDATE
1004: ,fnd_global.user_id
1005: ,SYSDATE
1006: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1004: ,fnd_global.user_id

1000: ,'Y' -- Default Registration Flag
1001: ,'MIGRATED' -- Record Type
1002: ,fnd_global.user_id
1003: ,SYSDATE
1004: ,fnd_global.user_id
1005: ,SYSDATE
1006: ,FND_GLOBAL.CONC_LOGIN_ID
1007: FROM ap_supplier_sites_all PVS,
1008: ap_suppliers PV,

Line 1006: ,FND_GLOBAL.CONC_LOGIN_ID

1002: ,fnd_global.user_id
1003: ,SYSDATE
1004: ,fnd_global.user_id
1005: ,SYSDATE
1006: ,FND_GLOBAL.CONC_LOGIN_ID
1007: FROM ap_supplier_sites_all PVS,
1008: ap_suppliers PV,
1009: zx_party_tax_profile PTP
1010: WHERE p_vendor_site_id = PTP.Party_ID

Line 1068: ,fnd_global.user_id

1064: ,NULL -- Rep_Party_Tax_Name
1065: ,NULL -- Legal Registration_ID
1066: ,'N' -- Default Registration Flag
1067: ,'MIGRATED' -- Record Type
1068: ,fnd_global.user_id
1069: ,SYSDATE
1070: ,fnd_global.user_id
1071: ,SYSDATE
1072: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1070: ,fnd_global.user_id

1066: ,'N' -- Default Registration Flag
1067: ,'MIGRATED' -- Record Type
1068: ,fnd_global.user_id
1069: ,SYSDATE
1070: ,fnd_global.user_id
1071: ,SYSDATE
1072: ,FND_GLOBAL.CONC_LOGIN_ID
1073: FROM ap_suppliers PV,
1074: zx_party_tax_profile PTP

Line 1072: ,FND_GLOBAL.CONC_LOGIN_ID

1068: ,fnd_global.user_id
1069: ,SYSDATE
1070: ,fnd_global.user_id
1071: ,SYSDATE
1072: ,FND_GLOBAL.CONC_LOGIN_ID
1073: FROM ap_suppliers PV,
1074: zx_party_tax_profile PTP
1075: WHERE p_vendor_site_id = PTP.Party_ID
1076: AND PTP.Party_Type_code = 'SUPPLIER_SITE'

Line 1132: ,fnd_global.user_id

1128: ,NULL -- Rep_Party_Tax_Name
1129: ,NULL -- Legal Registration_ID
1130: ,'N' -- Default Registration Flag
1131: ,'MIGRATED' -- Record Type
1132: ,fnd_global.user_id
1133: ,SYSDATE
1134: ,fnd_global.user_id
1135: ,SYSDATE
1136: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1134: ,fnd_global.user_id

1130: ,'N' -- Default Registration Flag
1131: ,'MIGRATED' -- Record Type
1132: ,fnd_global.user_id
1133: ,SYSDATE
1134: ,fnd_global.user_id
1135: ,SYSDATE
1136: ,FND_GLOBAL.CONC_LOGIN_ID
1137: FROM ap_supplier_sites_all PVS,
1138: ap_suppliers PV,

Line 1136: ,FND_GLOBAL.CONC_LOGIN_ID

1132: ,fnd_global.user_id
1133: ,SYSDATE
1134: ,fnd_global.user_id
1135: ,SYSDATE
1136: ,FND_GLOBAL.CONC_LOGIN_ID
1137: FROM ap_supplier_sites_all PVS,
1138: ap_suppliers PV,
1139: zx_party_tax_profile PTP
1140: WHERE p_vendor_site_id = PTP.Party_ID

Line 1164: Last_Updated_By=fnd_global.user_id,

1160: DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1161: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1162: TAX_CLASSIFICATION_CODE=p_vat_code, -- Tax Classification
1163: Allow_Offset_Tax_Flag =nvl(p_offset_tax_flag,'N'), -- Allow_Offset_Tax_Flag
1164: Last_Updated_By=fnd_global.user_id,
1165: Last_Update_Date=SYSDATE,
1166: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1167: WHERE party_tax_profile_id= p_VENDOR_SITE_ID
1168: and party_TYPE_CODE = 'SUPPLIER_SITE'

Line 1166: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID

1162: TAX_CLASSIFICATION_CODE=p_vat_code, -- Tax Classification
1163: Allow_Offset_Tax_Flag =nvl(p_offset_tax_flag,'N'), -- Allow_Offset_Tax_Flag
1164: Last_Updated_By=fnd_global.user_id,
1165: Last_Update_Date=SYSDATE,
1166: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1167: WHERE party_tax_profile_id= p_VENDOR_SITE_ID
1168: and party_TYPE_CODE = 'SUPPLIER_SITE'
1169: and p_vendor_id in ( SELECT vendor_id
1170: FROM ap_suppliers

Line 1185: Last_Updated_By=fnd_global.user_id,

1181: UPDATE ZX_REGISTRATIONS
1182: SET Registration_Number = P_Vat_Registration_Num, -- Reg Number
1183: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1184: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1185: Last_Updated_By=fnd_global.user_id,
1186: Last_Update_Date=SYSDATE,
1187: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1188: WHERE Party_tax_profile_id in (select party_tax_profile_id
1189: from zx_party_tax_profile where party_id

Line 1187: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID

1183: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1184: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1185: Last_Updated_By=fnd_global.user_id,
1186: Last_Update_Date=SYSDATE,
1187: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1188: WHERE Party_tax_profile_id in (select party_tax_profile_id
1189: from zx_party_tax_profile where party_id
1190: = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1191:

Line 1203: LAST_UPDATED_BY = fnd_global.user_id,

1199: -- Update the Fiscal Printer Codes into Association table
1200:
1201: UPDATE ZX_REPORT_CODES_ASSOC
1202: SET REPORTING_CODE_CHAR_VALUE = p_GLOBAL_ATTRIBUTE18,
1203: LAST_UPDATED_BY = fnd_global.user_id,
1204: LAST_UPDATE_DATE = sysdate,
1205: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1206: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1207: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID

Line 1205: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

1201: UPDATE ZX_REPORT_CODES_ASSOC
1202: SET REPORTING_CODE_CHAR_VALUE = p_GLOBAL_ATTRIBUTE18,
1203: LAST_UPDATED_BY = fnd_global.user_id,
1204: LAST_UPDATE_DATE = sysdate,
1205: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1206: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1207: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1208: FROM ZX_REPORTING_TYPES_B
1209: WHERE REPORTING_TYPE_CODE ='FISCAL PRINTER')

Line 1221: LAST_UPDATED_BY = fnd_global.user_id,

1217:
1218: UPDATE ZX_REPORT_CODES_ASSOC
1219: SET REPORTING_CODE_NUM_VALUE = p_GLOBAL_ATTRIBUTE19,
1220: EFFECTIVE_TO = p_GLOBAL_ATTRIBUTE20,
1221: LAST_UPDATED_BY = fnd_global.user_id,
1222: LAST_UPDATE_DATE = sysdate,
1223: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1224: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1225: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID

Line 1223: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

1219: SET REPORTING_CODE_NUM_VALUE = p_GLOBAL_ATTRIBUTE19,
1220: EFFECTIVE_TO = p_GLOBAL_ATTRIBUTE20,
1221: LAST_UPDATED_BY = fnd_global.user_id,
1222: LAST_UPDATE_DATE = sysdate,
1223: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1224: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1225: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1226: FROM ZX_REPORTING_TYPES_B
1227: WHERE REPORTING_TYPE_CODE ='CAI NUMBER')

Line 1245: Last_Updated_By=fnd_global.user_id,

1241: SET Registration_Number = p_Global_Attribute10||' / '||p_Global_Attribute11||' / '||p_Global_Attribute12, --Reg Num
1242: Tax_Regime_Code = 'BR-IPI',
1243: ROUNDING_RULE_CODE= DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1244: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1245: Last_Updated_By=fnd_global.user_id,
1246: Last_Update_Date=SYSDATE,
1247: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1248: WHERE Party_tax_profile_id in (select party_tax_profile_id
1249: from zx_party_tax_profile where party_id

Line 1247: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID

1243: ROUNDING_RULE_CODE= DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1244: Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1245: Last_Updated_By=fnd_global.user_id,
1246: Last_Update_Date=SYSDATE,
1247: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1248: WHERE Party_tax_profile_id in (select party_tax_profile_id
1249: from zx_party_tax_profile where party_id
1250: = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1251:

Line 1260: Last_Updated_By=fnd_global.user_id,

1256: SET Registration_Number = p_Global_Attribute13,-- State Registration Num,
1257: Tax_Regime_Code = 'BR-ICMS',
1258: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1259: Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1260: Last_Updated_By=fnd_global.user_id,
1261: Last_Update_Date=SYSDATE,
1262: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1263: WHERE Party_tax_profile_id in (select party_tax_profile_id
1264: from zx_party_tax_profile where party_id

Line 1262: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID

1258: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1259: Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1260: Last_Updated_By=fnd_global.user_id,
1261: Last_Update_Date=SYSDATE,
1262: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1263: WHERE Party_tax_profile_id in (select party_tax_profile_id
1264: from zx_party_tax_profile where party_id
1265: = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1266:

Line 1275: Last_Updated_By=fnd_global.user_id,

1271: SET Registration_Number = p_Global_Attribute14,-- City Registration Num,
1272: Tax_Regime_Code = 'BR-ISS',
1273: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1274: Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1275: Last_Updated_By=fnd_global.user_id,
1276: Last_Update_Date=SYSDATE,
1277: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1278: WHERE Party_tax_profile_id in (select party_tax_profile_id
1279: from zx_party_tax_profile where party_id

Line 1277: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID

1273: ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1274: Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1275: Last_Updated_By=fnd_global.user_id,
1276: Last_Update_Date=SYSDATE,
1277: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1278: WHERE Party_tax_profile_id in (select party_tax_profile_id
1279: from zx_party_tax_profile where party_id
1280: = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1281: