DBA Data[Home] [Help]

APPS.ZX_PTP_MIGRATE_PKG dependencies on ZX_PARTY_TAX_PROFILE_S

Line 649: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

645: Last_Update_Date,
646: Last_Update_Login,
647: OBJECT_VERSION_NUMBER)
648: (SELECT
649: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
650: ,XEP.Party_ID -- Party_Id
651: ,'FIRST_PARTY' -- Party Type
652: ,'N' -- Customer_Flag
653: ,'Y' -- First Party LE Flag

Line 760: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

756: Last_Update_Login,
757: OBJECT_VERSION_NUMBER
758: )
759: SELECT
760: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
761: ,XEP.Party_Id --Party_Id
762: --Bug 4361933
763: ,nvl(hrorginfo.org_information2,
764: nvl(decode(hrloc.GLOBAL_ATTRIBUTE_CATEGORY,

Line 1273: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

1269: ,Last_Update_Date
1270: ,Last_Update_Login
1271: ,OBJECT_VERSION_NUMBER)
1272: (SELECT
1273: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
1274: ,PARTY_ID -- Party ID
1275: ,decode(pv.GLOBAL_ATTRIBUTE_CATEGORY,
1276: 'JL.AR.APXVDMVD.SUPPLIERS',pv.Global_Attribute12||pv.num_1099,
1277: 'JL.CL.APXVDMVD.SUPPLIERS',pv.Global_Attribute12||pv.num_1099,

Line 1581: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

1577: ,Last_Update_Login
1578: ,Object_Version_Number)
1579:
1580: VALUES(
1581: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
1582: PARTY_SITE_ID,
1583: VAT_REGISTRATION_NUM
1584: ,'THIRD_PARTY_SITE' -- Party Type
1585: ,'N' -- Customer_Flag

Line 1778: ZX_PARTY_TAX_PROFILE_S.NEXTVAL

1774: ,Last_Update_Date
1775: ,Last_Update_Login
1776: ,OBJECT_VERSION_NUMBER)
1777: (SELECT
1778: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
1779: ,pvs.VENDOR_SITE_ID -- Party ID
1780: ,'SUPPLIER_SITE' -- Party Type
1781: ,'N' -- Customer_Flag
1782: ,'N' -- First Party Flag

Line 2198: ZX_PARTY_TAX_PROFILE_S.NEXTVAL -- Party_Tax_Profile_Id

2194: Last_Update_Date,
2195: Last_Update_Login,
2196: OBJECT_VERSION_NUMBER)
2197: (SELECT
2198: ZX_PARTY_TAX_PROFILE_S.NEXTVAL -- Party_Tax_Profile_Id
2199: ,L_ORG_ID -- Party_Id
2200: ,'OU' -- Party_Type_code
2201: ,'N' -- Customer Flag
2202: ,'N' -- First_Party_Le_Flag

Line 2261: ZX_PARTY_TAX_PROFILE_S.NEXTVAL -- Party_Tax_Profile_Id

2257: Last_Update_Date,
2258: Last_Update_Login,
2259: OBJECT_VERSION_NUMBER)
2260: (SELECT
2261: ZX_PARTY_TAX_PROFILE_S.NEXTVAL -- Party_Tax_Profile_Id
2262: ,Organization_id -- Party_Id
2263: ,'OU' -- Party_Type_code
2264: ,'N' -- Customer Flag
2265: ,'N' -- First_Party_Le_Flag