DBA Data[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REPORT_CODES_ASSOC_S

Line 165: ZX_REPORT_CODES_ASSOC_S.nextval ,

161: REPORTING_CODE_NUM_VALUE,
162: OBJECT_VERSION_NUMBER
163: )
164: SELECT
165: ZX_REPORT_CODES_ASSOC_S.nextval ,
166: 'ZX_TAXES' ,--ENTITY_CODE
167: TAX_ID ,--ENTITY_ID
168: l_reporting_type_id ,--REPORTING_TYPE_ID
169: NULL ,--REPORTING_CODE_ID

Line 1233: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

1229: LAST_UPDATE_DATE,
1230: LAST_UPDATE_LOGIN,
1231: OBJECT_VERSION_NUMBER)
1232: (SELECT
1233: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1234: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1235: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1236: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1237: pvs.GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE

Line 1283: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

1279: LAST_UPDATE_DATE,
1280: LAST_UPDATE_LOGIN,
1281: OBJECT_VERSION_NUMBER)
1282: (SELECT
1283: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1284: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1285: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1286: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1287: pvs.GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE

Line 1336: ZX_REPORT_CODES_ASSOC_S.nextval ,

1332: REPORTING_CODE_NUM_VALUE,
1333: OBJECT_VERSION_NUMBER
1334: )
1335: (SELECT
1336: ZX_REPORT_CODES_ASSOC_S.nextval ,
1337: 'ZX_RATES' ,--ENTITY_CODE
1338: rates.TAX_RATE_ID ,--ENTITY_ID
1339: report_codes.REPORTING_TYPE_ID ,
1340: report_codes.REPORTING_CODE_ID ,

Line 1400: ZX_REPORT_CODES_ASSOC_S.nextval ,

1396: REPORTING_CODE_NUM_VALUE,
1397: OBJECT_VERSION_NUMBER
1398: )
1399: SELECT
1400: ZX_REPORT_CODES_ASSOC_S.nextval ,
1401: 'ZX_RATES' ,--ENTITY_CODE
1402: TAX_RATE_ID ,--ENTITY_ID
1403: REPORTING_TYPE_ID ,
1404: REPORTING_CODE_ID ,

Line 1819: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

1815: LAST_UPDATE_DATE,
1816: LAST_UPDATE_LOGIN,
1817: OBJECT_VERSION_NUMBER) -- Bug 5031787
1818: (SELECT
1819: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1820: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1821: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1822: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1823: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID

Line 1875: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

1871: LAST_UPDATE_DATE,
1872: LAST_UPDATE_LOGIN,
1873: OBJECT_VERSION_NUMBER) -- Bug 5031787
1874: (SELECT
1875: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1876: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1877: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1878: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1879: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID

Line 1938: ZX_REPORT_CODES_ASSOC_S.nextval ,

1934: REPORTING_CODE_NUM_VALUE,
1935: OBJECT_VERSION_NUMBER
1936: )
1937: SELECT
1938: ZX_REPORT_CODES_ASSOC_S.nextval ,
1939: 'ZX_RATES' ,--ENTITY_CODE
1940: rates.TAX_RATE_ID ,--ENTITY_ID
1941: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
1942: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID

Line 2017: ZX_REPORT_CODES_ASSOC_S.nextval ,

2013: REPORTING_CODE_NUM_VALUE,
2014: OBJECT_VERSION_NUMBER
2015: )
2016: SELECT
2017: ZX_REPORT_CODES_ASSOC_S.nextval ,
2018: 'ZX_RATES' ,--ENTITY_CODE
2019: TAX_RATE_ID ,--ENTITY_ID
2020: REPORTING_TYPE_ID ,
2021: REPORTING_CODE_ID ,

Line 2704: ZX_REPORT_CODES_ASSOC_S.nextval ,

2700: REPORTING_CODE_NUM_VALUE,
2701: OBJECT_VERSION_NUMBER
2702: )
2703: SELECT
2704: ZX_REPORT_CODES_ASSOC_S.nextval ,
2705: 'ZX_RATES' ,--ENTITY_CODE
2706: TAX_RATE_ID ,--ENTITY_ID
2707: REPORTING_TYPE_ID ,
2708: NULL ,--REPORTING_CODE_ID

Line 2884: ZX_REPORT_CODES_ASSOC_S.nextval ,

2880: LAST_UPDATE_LOGIN ,
2881: OBJECT_VERSION_NUMBER
2882: )
2883: SELECT
2884: ZX_REPORT_CODES_ASSOC_S.nextval ,
2885: 'ZX_RATES' ,--ENTITY_CODE
2886: TAX_RATE_ID ,--ENTITY_ID
2887: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID
2888: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE

Line 4030: ZX_REPORT_CODES_ASSOC_S.nextval ,

4026: REPORTING_CODE_NUM_VALUE,
4027: OBJECT_VERSION_NUMBER
4028: )
4029: SELECT
4030: ZX_REPORT_CODES_ASSOC_S.nextval ,
4031: 'ZX_RATES' ,--ENTITY_CODE
4032: TAX_RATE_ID ,--ENTITY_ID
4033: REPORTING_TYPE_ID ,
4034: REPORTING_CODE_ID ,

Line 5765: ZX_REPORT_CODES_ASSOC_S.nextval ,

5761: REPORTING_CODE_NUM_VALUE,
5762: OBJECT_VERSION_NUMBER
5763: )
5764: SELECT
5765: ZX_REPORT_CODES_ASSOC_S.nextval ,
5766: 'ZX_RATES' ,--ENTITY_CODE
5767: TAX_RATE_ID ,--ENTITY_ID
5768: REPORTING_TYPE_ID ,
5769: REPORTING_CODE_ID ,

Line 5924: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

5920: LAST_UPDATE_DATE,
5921: LAST_UPDATE_LOGIN,
5922: OBJECT_VERSION_NUMBER)
5923: SELECT
5924: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
5925: 'ZX_PARTY_TAX_PROFILE' , --ENTITY_CODE
5926: p_ptp_id , --ENTITY_ID
5927: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
5928: p_rep_type_info, --REPORTING_CODE_CHAR_VALUE

Line 7347: ZX_REPORT_CODES_ASSOC_S.nextval ,

7343: REPORTING_CODE_NUM_VALUE,
7344: OBJECT_VERSION_NUMBER
7345: )
7346: SELECT
7347: ZX_REPORT_CODES_ASSOC_S.nextval ,
7348: 'ZX_RATES' ,--ENTITY_CODE
7349: rates.TAX_RATE_ID ,--ENTITY_ID
7350: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7351: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID

Line 7419: ZX_REPORT_CODES_ASSOC_S.nextval ,

7415: REPORTING_CODE_NUM_VALUE,
7416: OBJECT_VERSION_NUMBER
7417: )
7418: SELECT
7419: ZX_REPORT_CODES_ASSOC_S.nextval ,
7420: 'ZX_RATES' ,--ENTITY_CODE
7421: rates.TAX_RATE_ID ,--ENTITY_ID
7422: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7423: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID

Line 7772: ZX_REPORT_CODES_ASSOC_S.nextval ,

7768: REPORTING_CODE_NUM_VALUE,
7769: OBJECT_VERSION_NUMBER
7770: )
7771: SELECT
7772: ZX_REPORT_CODES_ASSOC_S.nextval ,
7773: 'ZX_RATES' ,--ENTITY_CODE
7774: rates.TAX_RATE_ID ,--ENTITY_ID
7775: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7776: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID

Line 8269: ZX_REPORT_CODES_ASSOC_S.nextval,

8265: REPORTING_CODE_DATE_VALUE,
8266: REPORTING_CODE_NUM_VALUE,
8267: OBJECT_VERSION_NUMBER)
8268: SELECT
8269: ZX_REPORT_CODES_ASSOC_S.nextval,
8270: ''ZX_RATES'',
8271: TAX_RATE_ID,
8272: REPORTING_TYPE_ID,
8273: REPORTING_CODE_ID,

Line 8337: ZX_REPORT_CODES_ASSOC_S.nextval,

8333: REPORTING_CODE_DATE_VALUE,
8334: REPORTING_CODE_NUM_VALUE,
8335: OBJECT_VERSION_NUMBER)
8336: SELECT
8337: ZX_REPORT_CODES_ASSOC_S.nextval,
8338: ''ZX_RATES'',
8339: TAX_RATE_ID,
8340: REPORTING_TYPE_ID,
8341: REPORTING_CODE_ID,