DBA Data[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REPORT_CODES_ASSOC_S

Line 150: ZX_REPORT_CODES_ASSOC_S.nextval ,

146: REPORTING_CODE_NUM_VALUE,
147: OBJECT_VERSION_NUMBER
148: )
149: SELECT
150: ZX_REPORT_CODES_ASSOC_S.nextval ,
151: 'ZX_TAXES' ,--ENTITY_CODE
152: TAX_ID ,--ENTITY_ID
153: l_reporting_type_id ,--REPORTING_TYPE_ID
154: NULL ,--REPORTING_CODE_ID

Line 1218: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

1214: LAST_UPDATE_DATE,
1215: LAST_UPDATE_LOGIN,
1216: OBJECT_VERSION_NUMBER)
1217: (SELECT
1218: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1219: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1220: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1221: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1222: pvs.GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE

Line 1268: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

1264: LAST_UPDATE_DATE,
1265: LAST_UPDATE_LOGIN,
1266: OBJECT_VERSION_NUMBER)
1267: (SELECT
1268: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1269: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1270: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1271: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1272: pvs.GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE

Line 1321: ZX_REPORT_CODES_ASSOC_S.nextval ,

1317: REPORTING_CODE_NUM_VALUE,
1318: OBJECT_VERSION_NUMBER
1319: )
1320: (SELECT
1321: ZX_REPORT_CODES_ASSOC_S.nextval ,
1322: 'ZX_RATES' ,--ENTITY_CODE
1323: rates.TAX_RATE_ID ,--ENTITY_ID
1324: report_codes.REPORTING_TYPE_ID ,
1325: report_codes.REPORTING_CODE_ID ,

Line 1385: ZX_REPORT_CODES_ASSOC_S.nextval ,

1381: REPORTING_CODE_NUM_VALUE,
1382: OBJECT_VERSION_NUMBER
1383: )
1384: SELECT
1385: ZX_REPORT_CODES_ASSOC_S.nextval ,
1386: 'ZX_RATES' ,--ENTITY_CODE
1387: TAX_RATE_ID ,--ENTITY_ID
1388: REPORTING_TYPE_ID ,
1389: REPORTING_CODE_ID ,

Line 1801: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

1797: LAST_UPDATE_DATE,
1798: LAST_UPDATE_LOGIN,
1799: OBJECT_VERSION_NUMBER) -- Bug 5031787
1800: (SELECT
1801: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1802: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1803: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1804: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1805: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID

Line 1851: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

1847: LAST_UPDATE_DATE,
1848: LAST_UPDATE_LOGIN,
1849: OBJECT_VERSION_NUMBER) -- Bug 5031787
1850: (SELECT
1851: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
1852: 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
1853: ptp.Party_Tax_Profile_Id, --ENTITY_ID
1854: codes.REPORTING_TYPE_ID , --REPORTING_TYPE_ID
1855: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID

Line 1911: ZX_REPORT_CODES_ASSOC_S.nextval ,

1907: REPORTING_CODE_NUM_VALUE,
1908: OBJECT_VERSION_NUMBER
1909: )
1910: SELECT
1911: ZX_REPORT_CODES_ASSOC_S.nextval ,
1912: 'ZX_RATES' ,--ENTITY_CODE
1913: rates.TAX_RATE_ID ,--ENTITY_ID
1914: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
1915: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID

Line 1990: ZX_REPORT_CODES_ASSOC_S.nextval ,

1986: REPORTING_CODE_NUM_VALUE,
1987: OBJECT_VERSION_NUMBER
1988: )
1989: SELECT
1990: ZX_REPORT_CODES_ASSOC_S.nextval ,
1991: 'ZX_RATES' ,--ENTITY_CODE
1992: TAX_RATE_ID ,--ENTITY_ID
1993: REPORTING_TYPE_ID ,
1994: REPORTING_CODE_ID ,

Line 2677: ZX_REPORT_CODES_ASSOC_S.nextval ,

2673: REPORTING_CODE_NUM_VALUE,
2674: OBJECT_VERSION_NUMBER
2675: )
2676: SELECT
2677: ZX_REPORT_CODES_ASSOC_S.nextval ,
2678: 'ZX_RATES' ,--ENTITY_CODE
2679: TAX_RATE_ID ,--ENTITY_ID
2680: REPORTING_TYPE_ID ,
2681: NULL ,--REPORTING_CODE_ID

Line 2857: ZX_REPORT_CODES_ASSOC_S.nextval ,

2853: LAST_UPDATE_LOGIN ,
2854: OBJECT_VERSION_NUMBER
2855: )
2856: SELECT
2857: ZX_REPORT_CODES_ASSOC_S.nextval ,
2858: 'ZX_RATES' ,--ENTITY_CODE
2859: TAX_RATE_ID ,--ENTITY_ID
2860: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID
2861: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE

Line 4003: ZX_REPORT_CODES_ASSOC_S.nextval ,

3999: REPORTING_CODE_NUM_VALUE,
4000: OBJECT_VERSION_NUMBER
4001: )
4002: SELECT
4003: ZX_REPORT_CODES_ASSOC_S.nextval ,
4004: 'ZX_RATES' ,--ENTITY_CODE
4005: TAX_RATE_ID ,--ENTITY_ID
4006: REPORTING_TYPE_ID ,
4007: REPORTING_CODE_ID ,

Line 5736: ZX_REPORT_CODES_ASSOC_S.nextval ,

5732: REPORTING_CODE_NUM_VALUE,
5733: OBJECT_VERSION_NUMBER
5734: )
5735: SELECT
5736: ZX_REPORT_CODES_ASSOC_S.nextval ,
5737: 'ZX_RATES' ,--ENTITY_CODE
5738: TAX_RATE_ID ,--ENTITY_ID
5739: REPORTING_TYPE_ID ,
5740: REPORTING_CODE_ID ,

Line 5895: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID

5891: LAST_UPDATE_DATE,
5892: LAST_UPDATE_LOGIN,
5893: OBJECT_VERSION_NUMBER)
5894: SELECT
5895: ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
5896: 'ZX_PARTY_TAX_PROFILE' , --ENTITY_CODE
5897: p_ptp_id , --ENTITY_ID
5898: REPORTING_TYPE_ID , --REPORTING_TYPE_ID
5899: p_rep_type_info, --REPORTING_CODE_CHAR_VALUE

Line 7317: ZX_REPORT_CODES_ASSOC_S.nextval ,

7313: REPORTING_CODE_NUM_VALUE,
7314: OBJECT_VERSION_NUMBER
7315: )
7316: SELECT
7317: ZX_REPORT_CODES_ASSOC_S.nextval ,
7318: 'ZX_RATES' ,--ENTITY_CODE
7319: rates.TAX_RATE_ID ,--ENTITY_ID
7320: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7321: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID

Line 7389: ZX_REPORT_CODES_ASSOC_S.nextval ,

7385: REPORTING_CODE_NUM_VALUE,
7386: OBJECT_VERSION_NUMBER
7387: )
7388: SELECT
7389: ZX_REPORT_CODES_ASSOC_S.nextval ,
7390: 'ZX_RATES' ,--ENTITY_CODE
7391: rates.TAX_RATE_ID ,--ENTITY_ID
7392: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7393: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID

Line 7742: ZX_REPORT_CODES_ASSOC_S.nextval ,

7738: REPORTING_CODE_NUM_VALUE,
7739: OBJECT_VERSION_NUMBER
7740: )
7741: SELECT
7742: ZX_REPORT_CODES_ASSOC_S.nextval ,
7743: 'ZX_RATES' ,--ENTITY_CODE
7744: rates.TAX_RATE_ID ,--ENTITY_ID
7745: report_codes.REPORTING_TYPE_ID, --REPORTING_TYPE_ID
7746: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID