APPS.ZX_PTP_MIGRATE_PKG dependencies on ZX_PARTY_TAX_PROFILE_S

Line 660: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

656: Last_Update_Date,
657: Last_Update_Login,
658: OBJECT_VERSION_NUMBER)
659: (SELECT
660: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
661: ,XEP.Party_ID -- Party_Id
662: ,'FIRST_PARTY' -- Party Type
663: ,'N' -- Customer_Flag
664: ,'Y' -- First Party LE Flag

Line 773: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

769: Last_Update_Login,
770: OBJECT_VERSION_NUMBER
771: )
772: SELECT
773: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
774: ,XEP.Party_Id --Party_Id
775: --Bug 4361933
776: ,nvl((SELECT HrOrgInfo.ORG_INFORMATION2 FROM Hr_Organization_Information HrOrgInfo
777: WHERE HrOrgInfo.Org_Information_Context = 'Legal Entity Accounting'

Line 880: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

876: Last_Update_Login,
877: OBJECT_VERSION_NUMBER
878: )
879: SELECT
880: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
881: ,XEP.Party_Id --Party_Id
882: --Bug 4361933
883: ,nvl(hrorginfo.org_information2,
884: nvl(decode(hrloc.GLOBAL_ATTRIBUTE_CATEGORY,

Line 1393: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

1389: ,Last_Update_Date
1390: ,Last_Update_Login
1391: ,OBJECT_VERSION_NUMBER)
1392: (SELECT
1393: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
1394: ,PARTY_ID -- Party ID
1395: ,decode(pv.GLOBAL_ATTRIBUTE_CATEGORY,
1396: 'JL.AR.APXVDMVD.SUPPLIERS',pv.Global_Attribute12||pv.num_1099,
1397: 'JL.CL.APXVDMVD.SUPPLIERS',pv.Global_Attribute12||pv.num_1099,

Line 1701: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

1697: ,Last_Update_Login
1698: ,Object_Version_Number)
1699:
1700: VALUES(
1701: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
1702: PARTY_SITE_ID,
1703: VAT_REGISTRATION_NUM
1704: ,'THIRD_PARTY_SITE' -- Party Type
1705: ,'N' -- Customer_Flag

Line 1898: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

1894: ,Last_Update_Date
1895: ,Last_Update_Login
1896: ,OBJECT_VERSION_NUMBER)
1897: (SELECT
1898: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
1899: ,pvs.VENDOR_SITE_ID -- Party ID
1900: ,'SUPPLIER_SITE' -- Party Type
1901: ,'N' -- Customer_Flag
1902: ,'N' -- First Party Flag

Line 2318: ZX_PARTY_TAX_PROFILE_S.NEXTVAL -- Party_Tax_Profile_Id

2314: Last_Update_Date,
2315: Last_Update_Login,
2316: OBJECT_VERSION_NUMBER)
2317: (SELECT
2318: ZX_PARTY_TAX_PROFILE_S.NEXTVAL -- Party_Tax_Profile_Id
2319: ,L_ORG_ID -- Party_Id
2320: ,'OU' -- Party_Type_code
2321: ,'N' -- Customer Flag
2322: ,'N' -- First_Party_Le_Flag

Line 2381: ZX_PARTY_TAX_PROFILE_S.NEXTVAL -- Party_Tax_Profile_Id

2377: Last_Update_Date,
2378: Last_Update_Login,
2379: OBJECT_VERSION_NUMBER)
2380: (SELECT
2381: ZX_PARTY_TAX_PROFILE_S.NEXTVAL -- Party_Tax_Profile_Id
2382: ,Organization_id -- Party_Id
2383: ,'OU' -- Party_Type_code
2384: ,'N' -- Customer Flag
2385: ,'N' -- First_Party_Le_Flag