eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on AP_TAX_CODES_ALL

Line 193: | on data in AP_TAX_CODES_ALL GDF attributes. |

189: | CREATE_ZX_REP_TYPES_CODES |
190: | |
191: | DESCRIPTION |
192: | This routine inserts data into following zx reporting entities based |
193: | on data in AP_TAX_CODES_ALL GDF attributes. |
194: | ZX_REPORTING_TYPES_B |
195: | ZX_REPORTING_TYPES_TL |
196: | ZX_REPORTING_CODES_B |
197: | ZX_REPORTING_CODES_TL |

Line 1023: ap_tax_codes_all codes,

1019: SELECT
1020: min(zx_rates.effective_from) effective_from,
1021: zx_rates.tax_regime_code l_tax_regime_code
1022: FROM
1023: ap_tax_codes_all codes,
1024: zx_rates_b zx_rates
1025: WHERE
1026: codes.tax_id = zx_rates.tax_rate_id
1027: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 1340: AP_TAX_CODES_ALL codes,

1336: report_codes.REPORTING_CODE_NUM_VALUE ,
1337: 1
1338: FROM
1339:
1340: AP_TAX_CODES_ALL codes,
1341: ZX_RATES_B rates,
1342: ZX_REPORTING_CODES_B report_codes
1343: WHERE
1344: codes.tax_id = rates.tax_rate_id

Line 1413: AP_TAX_CODES_ALL codes,

1409: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1410: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1411: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1412: FROM
1413: AP_TAX_CODES_ALL codes,
1414: ZX_RATES_B rates,
1415: ZX_REPORTING_TYPES_B reporting_types,
1416: ZX_REPORTING_CODES_B report_codes
1417: WHERE

Line 1445: AP_TAX_CODES_ALL codes,

1441: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1442: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1443: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1444: FROM
1445: AP_TAX_CODES_ALL codes,
1446: ZX_RATES_B rates,
1447: ZX_REPORTING_TYPES_B reporting_types,
1448: ZX_REPORTING_CODES_B report_codes
1449: WHERE

Line 1476: AP_TAX_CODES_ALL codes,

1472: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1473: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1474: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1475: FROM
1476: AP_TAX_CODES_ALL codes,
1477: ZX_RATES_B rates,
1478: ZX_REPORTING_TYPES_B reporting_types,
1479: ZX_REPORTING_CODES_B report_codes
1480: WHERE

Line 1507: AP_TAX_CODES_ALL codes,

1503: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1504: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1505: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1506: FROM
1507: AP_TAX_CODES_ALL codes,
1508: ZX_RATES_B rates,
1509: ZX_REPORTING_TYPES_B reporting_types,
1510: ZX_REPORTING_CODES_B report_codes
1511: WHERE

Line 1538: AP_TAX_CODES_ALL codes,

1534: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1535: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1536: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1537: FROM
1538: AP_TAX_CODES_ALL codes,
1539: ZX_RATES_B rates,
1540: ZX_REPORTING_TYPES_B reporting_types,
1541: ZX_REPORTING_CODES_B report_codes
1542: WHERE

Line 1569: AP_TAX_CODES_ALL codes,

1565: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1566: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1567: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1568: FROM
1569: AP_TAX_CODES_ALL codes,
1570: ZX_RATES_B rates,
1571: ZX_REPORTING_TYPES_B reporting_types,
1572: ZX_REPORTING_CODES_B report_codes
1573: WHERE

Line 1603: AP_TAX_CODES_ALL codes,

1599: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE,
1600: NULL REPORTING_CODE_DATE_VALUE,
1601: NULL REPORTING_CODE_NUM_VALUE
1602: FROM
1603: AP_TAX_CODES_ALL codes,
1604: ZX_RATES_B rates,
1605: ZX_REPORTING_TYPES_B reporting_types
1606: -- ZX_REPORTING_CODES_B report_codes
1607: WHERE

Line 1633: AP_TAX_CODES_ALL codes,

1629: codes.global_attribute3 REPORTING_CODE_CHAR_VALUE,
1630: NULL REPORTING_CODE_DATE_VALUE,
1631: NULL REPORTING_CODE_NUM_VALUE
1632: FROM
1633: AP_TAX_CODES_ALL codes,
1634: ZX_RATES_B rates,
1635: ZX_REPORTING_TYPES_B reporting_types
1636: -- ZX_REPORTING_CODES_B report_codes
1637: WHERE

Line 1664: AP_TAX_CODES_ALL codes,

1660: codes.global_attribute4 REPORTING_CODE_CHAR_VALUE,
1661: NULL REPORTING_CODE_DATE_VALUE,
1662: NULL REPORTING_CODE_NUM_VALUE
1663: FROM
1664: AP_TAX_CODES_ALL codes,
1665: ZX_RATES_B rates,
1666: ZX_REPORTING_TYPES_B reporting_types
1667: -- ZX_REPORTING_CODES_B report_codes
1668: WHERE

Line 1695: AP_TAX_CODES_ALL codes,

1691: codes.global_attribute5 REPORTING_CODE_CHAR_VALUE,
1692: NULL REPORTING_CODE_DATE_VALUE,
1693: NULL REPORTING_CODE_NUM_VALUE
1694: FROM
1695: AP_TAX_CODES_ALL codes,
1696: ZX_RATES_B rates,
1697: ZX_REPORTING_TYPES_B reporting_types
1698: -- ZX_REPORTING_CODES_B report_codes
1699: WHERE

Line 1726: AP_TAX_CODES_ALL codes,

1722: codes.global_attribute6 REPORTING_CODE_CHAR_VALUE,
1723: NULL REPORTING_CODE_DATE_VALUE,
1724: NULL REPORTING_CODE_NUM_VALUE
1725: FROM
1726: AP_TAX_CODES_ALL codes,
1727: ZX_RATES_B rates,
1728: ZX_REPORTING_TYPES_B reporting_types
1729: -- ZX_REPORTING_CODES_B report_codes
1730: WHERE

Line 1760: AP_TAX_CODES_ALL codes,

1756: NULL REPORTING_CODE_DATE_VALUE,
1757: NULL REPORTING_CODE_NUM_VALUE
1758:
1759: FROM
1760: AP_TAX_CODES_ALL codes,
1761: ZX_RATES_B rates,
1762: ZX_REPORTING_TYPES_B reporting_types
1763: -- ZX_REPORTING_CODES_B report_codes
1764: WHERE

Line 1929: AP_TAX_CODES_ALL codes,

1925: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
1926: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
1927: 1
1928: FROM
1929: AP_TAX_CODES_ALL codes,
1930: ZX_REPORTING_TYPES_B reporting_types,
1931: ZX_REPORTING_CODES_B report_codes,
1932: ZX_RATES_B rates
1933:

Line 3305: ap_tax_codes_all codes,

3301: SELECT
3302: min(zx_rates.effective_from) effective_from,
3303: zx_rates.tax_regime_code l_tax_regime_code
3304: FROM
3305: ap_tax_codes_all codes,
3306: zx_rates_b zx_rates
3307: WHERE
3308: codes.tax_id = zx_rates.tax_rate_id
3309: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 3380: ap_tax_codes_all codes,

3376: SELECT
3377: min(zx_rates.effective_from) effective_from,
3378: zx_rates.tax_regime_code l_tax_regime_code
3379: FROM
3380: ap_tax_codes_all codes,
3381: zx_rates_b zx_rates
3382: WHERE
3383: codes.tax_id = zx_rates.tax_rate_id
3384: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 3455: ap_tax_codes_all codes,

3451: SELECT
3452: min(zx_rates.effective_from) effective_from,
3453: zx_rates.tax_regime_code l_tax_regime_code
3454: FROM
3455: ap_tax_codes_all codes,
3456: zx_rates_b zx_rates
3457: WHERE
3458: codes.tax_id = zx_rates.tax_rate_id
3459: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 3683: ap_tax_codes_all codes

3679: types.reporting_type_id reporting_type_id,
3680: types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
3681: FROM
3682: zx_reporting_types_b types,
3683: ap_tax_codes_all codes
3684:
3685: WHERE
3686: types.reporting_type_code = 'PT_PRD_TAXABLE_BOX'
3687: AND types.record_type_code = 'MIGRATED'

Line 3709: ap_tax_codes_all codes

3705: types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
3706:
3707: FROM
3708: zx_reporting_types_b types,
3709: ap_tax_codes_all codes
3710:
3711: WHERE
3712: types.reporting_type_code = 'PT_PRD_REC_TAX_BOX'
3713: AND types.record_type_code = 'MIGRATED'

Line 3735: ap_tax_codes_all codes

3731: types.reporting_type_id reporting_type_id,
3732: types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
3733: FROM
3734: zx_reporting_types_b types,
3735: ap_tax_codes_all codes
3736:
3737: WHERE
3738: types.reporting_type_code = 'PT_ANL_TTL_TAXABLE_BOX'
3739: AND types.record_type_code = 'MIGRATED'

Line 3760: ap_tax_codes_all codes

3756: types.reporting_type_id reporting_type_id,
3757: types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
3758: FROM
3759: zx_reporting_types_b types,
3760: ap_tax_codes_all codes
3761:
3762: WHERE
3763: types.reporting_type_code = 'PT_ANL_REC_TAXABLE'
3764: AND types.record_type_code = 'MIGRATED'

Line 3785: ap_tax_codes_all codes

3781: types.reporting_type_id reporting_type_id,
3782: types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
3783: FROM
3784: zx_reporting_types_b types,
3785: ap_tax_codes_all codes
3786:
3787: WHERE
3788: types.reporting_type_code = 'PT_ANL_NON_REC_TAXABLE'
3789: AND types.record_type_code = 'MIGRATED'

Line 3811: ap_tax_codes_all codes

3807: types.reporting_type_id reporting_type_id,
3808: types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
3809: FROM
3810: zx_reporting_types_b types,
3811: ap_tax_codes_all codes
3812:
3813: WHERE
3814: types.reporting_type_code = 'PT_ANL_REC_TAX_BOX'
3815: AND types.record_type_code = 'MIGRATED'

Line 3895: ap_tax_codes_all ap_tax,

3891: min(zx_rates.effective_from) effective_from,
3892: zx_rates.tax_regime_code l_tax_regime_code
3893:
3894: FROM
3895: ap_tax_codes_all ap_tax,
3896: zx_rates_b zx_rates
3897: WHERE
3898: ap_tax.tax_id = zx_rates.tax_rate_id
3899: AND ap_tax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'

Line 3962: from ap_tax_codes_all aptax, hr_locations hrloc

3958: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
3959: from
3960: (
3961: select tax_id,hrloc.location_code location_code
3962: from ap_tax_codes_all aptax, hr_locations hrloc
3963: where aptax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'
3964: and aptax.global_attribute1 = to_char(hrloc.location_id)
3965: ) tax_id_values_and_codes,
3966: zx_rates_b zxrb

Line 4031: AP_TAX_CODES_ALL codes,

4027: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
4028: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
4029: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
4030: FROM
4031: AP_TAX_CODES_ALL codes,
4032: HR_LOCATIONS hrloc,
4033: ZX_RATES_B rates,
4034: ZX_REPORTING_TYPES_B reporting_types,
4035: ZX_REPORTING_CODES_B report_codes

Line 7335: AP_TAX_CODES_ALL codes,

7331: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7332: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
7333: 1
7334: FROM
7335: AP_TAX_CODES_ALL codes,
7336: ZX_REPORTING_TYPES_B reporting_types,
7337: ZX_REPORTING_CODES_B report_codes,
7338: ZX_RATES_B rates,
7339: -- Bug 7620818