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 208: | on data in AP_TAX_CODES_ALL GDF attributes. |

204: | CREATE_ZX_REP_TYPES_CODES |
205: | |
206: | DESCRIPTION |
207: | This routine inserts data into following zx reporting entities based |
208: | on data in AP_TAX_CODES_ALL GDF attributes. |
209: | ZX_REPORTING_TYPES_B |
210: | ZX_REPORTING_TYPES_TL |
211: | ZX_REPORTING_CODES_B |
212: | ZX_REPORTING_CODES_TL |

Line 1038: ap_tax_codes_all codes,

1034: SELECT
1035: min(zx_rates.effective_from) effective_from,
1036: zx_rates.tax_regime_code l_tax_regime_code
1037: FROM
1038: ap_tax_codes_all codes,
1039: zx_rates_b zx_rates
1040: WHERE
1041: codes.tax_id = zx_rates.tax_rate_id
1042: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 1355: AP_TAX_CODES_ALL codes,

1351: report_codes.REPORTING_CODE_NUM_VALUE ,
1352: 1
1353: FROM
1354:
1355: AP_TAX_CODES_ALL codes,
1356: ZX_RATES_B rates,
1357: ZX_REPORTING_CODES_B report_codes
1358: WHERE
1359: codes.tax_id = rates.tax_rate_id

Line 1428: AP_TAX_CODES_ALL codes,

1424: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1425: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1426: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1427: FROM
1428: AP_TAX_CODES_ALL codes,
1429: ZX_RATES_B rates,
1430: ZX_REPORTING_TYPES_B reporting_types,
1431: ZX_REPORTING_CODES_B report_codes
1432: WHERE

Line 1460: AP_TAX_CODES_ALL codes,

1456: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1457: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1458: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1459: FROM
1460: AP_TAX_CODES_ALL codes,
1461: ZX_RATES_B rates,
1462: ZX_REPORTING_TYPES_B reporting_types,
1463: ZX_REPORTING_CODES_B report_codes
1464: WHERE

Line 1491: AP_TAX_CODES_ALL codes,

1487: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1488: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1489: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1490: FROM
1491: AP_TAX_CODES_ALL codes,
1492: ZX_RATES_B rates,
1493: ZX_REPORTING_TYPES_B reporting_types,
1494: ZX_REPORTING_CODES_B report_codes
1495: WHERE

Line 1522: AP_TAX_CODES_ALL codes,

1518: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1519: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1520: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1521: FROM
1522: AP_TAX_CODES_ALL codes,
1523: ZX_RATES_B rates,
1524: ZX_REPORTING_TYPES_B reporting_types,
1525: ZX_REPORTING_CODES_B report_codes
1526: WHERE

Line 1553: AP_TAX_CODES_ALL codes,

1549: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1550: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1551: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1552: FROM
1553: AP_TAX_CODES_ALL codes,
1554: ZX_RATES_B rates,
1555: ZX_REPORTING_TYPES_B reporting_types,
1556: ZX_REPORTING_CODES_B report_codes
1557: WHERE

Line 1584: AP_TAX_CODES_ALL codes,

1580: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
1581: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
1582: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
1583: FROM
1584: AP_TAX_CODES_ALL codes,
1585: ZX_RATES_B rates,
1586: ZX_REPORTING_TYPES_B reporting_types,
1587: ZX_REPORTING_CODES_B report_codes
1588: WHERE

Line 1618: AP_TAX_CODES_ALL codes,

1614: codes.global_attribute2 REPORTING_CODE_CHAR_VALUE,
1615: NULL REPORTING_CODE_DATE_VALUE,
1616: NULL REPORTING_CODE_NUM_VALUE
1617: FROM
1618: AP_TAX_CODES_ALL codes,
1619: ZX_RATES_B rates,
1620: ZX_REPORTING_TYPES_B reporting_types
1621: -- ZX_REPORTING_CODES_B report_codes
1622: WHERE

Line 1648: AP_TAX_CODES_ALL codes,

1644: codes.global_attribute3 REPORTING_CODE_CHAR_VALUE,
1645: NULL REPORTING_CODE_DATE_VALUE,
1646: NULL REPORTING_CODE_NUM_VALUE
1647: FROM
1648: AP_TAX_CODES_ALL codes,
1649: ZX_RATES_B rates,
1650: ZX_REPORTING_TYPES_B reporting_types
1651: -- ZX_REPORTING_CODES_B report_codes
1652: WHERE

Line 1679: AP_TAX_CODES_ALL codes,

1675: codes.global_attribute4 REPORTING_CODE_CHAR_VALUE,
1676: NULL REPORTING_CODE_DATE_VALUE,
1677: NULL REPORTING_CODE_NUM_VALUE
1678: FROM
1679: AP_TAX_CODES_ALL codes,
1680: ZX_RATES_B rates,
1681: ZX_REPORTING_TYPES_B reporting_types
1682: -- ZX_REPORTING_CODES_B report_codes
1683: WHERE

Line 1710: AP_TAX_CODES_ALL codes,

1706: codes.global_attribute5 REPORTING_CODE_CHAR_VALUE,
1707: NULL REPORTING_CODE_DATE_VALUE,
1708: NULL REPORTING_CODE_NUM_VALUE
1709: FROM
1710: AP_TAX_CODES_ALL codes,
1711: ZX_RATES_B rates,
1712: ZX_REPORTING_TYPES_B reporting_types
1713: -- ZX_REPORTING_CODES_B report_codes
1714: WHERE

Line 1741: AP_TAX_CODES_ALL codes,

1737: codes.global_attribute6 REPORTING_CODE_CHAR_VALUE,
1738: NULL REPORTING_CODE_DATE_VALUE,
1739: NULL REPORTING_CODE_NUM_VALUE
1740: FROM
1741: AP_TAX_CODES_ALL codes,
1742: ZX_RATES_B rates,
1743: ZX_REPORTING_TYPES_B reporting_types
1744: -- ZX_REPORTING_CODES_B report_codes
1745: WHERE

Line 1775: AP_TAX_CODES_ALL codes,

1771: NULL REPORTING_CODE_DATE_VALUE,
1772: NULL REPORTING_CODE_NUM_VALUE
1773:
1774: FROM
1775: AP_TAX_CODES_ALL codes,
1776: ZX_RATES_B rates,
1777: ZX_REPORTING_TYPES_B reporting_types
1778: -- ZX_REPORTING_CODES_B report_codes
1779: WHERE

Line 1956: AP_TAX_CODES_ALL codes,

1952: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
1953: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
1954: 1
1955: FROM
1956: AP_TAX_CODES_ALL codes,
1957: ZX_REPORTING_TYPES_B reporting_types,
1958: ZX_REPORTING_CODES_B report_codes,
1959: ZX_RATES_B rates
1960:

Line 3332: ap_tax_codes_all codes,

3328: SELECT
3329: min(zx_rates.effective_from) effective_from,
3330: zx_rates.tax_regime_code l_tax_regime_code
3331: FROM
3332: ap_tax_codes_all codes,
3333: zx_rates_b zx_rates
3334: WHERE
3335: codes.tax_id = zx_rates.tax_rate_id
3336: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 3407: ap_tax_codes_all codes,

3403: SELECT
3404: min(zx_rates.effective_from) effective_from,
3405: zx_rates.tax_regime_code l_tax_regime_code
3406: FROM
3407: ap_tax_codes_all codes,
3408: zx_rates_b zx_rates
3409: WHERE
3410: codes.tax_id = zx_rates.tax_rate_id
3411: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 3482: ap_tax_codes_all codes,

3478: SELECT
3479: min(zx_rates.effective_from) effective_from,
3480: zx_rates.tax_regime_code l_tax_regime_code
3481: FROM
3482: ap_tax_codes_all codes,
3483: zx_rates_b zx_rates
3484: WHERE
3485: codes.tax_id = zx_rates.tax_rate_id
3486: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 3710: ap_tax_codes_all codes

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

Line 3736: ap_tax_codes_all codes

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

Line 3762: ap_tax_codes_all codes

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

Line 3787: ap_tax_codes_all codes

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

Line 3812: ap_tax_codes_all codes

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

Line 3838: ap_tax_codes_all codes

3834: types.reporting_type_id reporting_type_id,
3835: types.REPORTING_TYPE_DATATYPE_CODE DATATYPE
3836: FROM
3837: zx_reporting_types_b types,
3838: ap_tax_codes_all codes
3839:
3840: WHERE
3841: types.reporting_type_code = 'PT_ANL_REC_TAX_BOX'
3842: AND types.record_type_code = 'MIGRATED'

Line 3922: ap_tax_codes_all ap_tax,

3918: min(zx_rates.effective_from) effective_from,
3919: zx_rates.tax_regime_code l_tax_regime_code
3920:
3921: FROM
3922: ap_tax_codes_all ap_tax,
3923: zx_rates_b zx_rates
3924: WHERE
3925: ap_tax.tax_id = zx_rates.tax_rate_id
3926: AND ap_tax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'

Line 3989: from ap_tax_codes_all aptax, hr_locations hrloc

3985: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
3986: from
3987: (
3988: select tax_id,hrloc.location_code location_code
3989: from ap_tax_codes_all aptax, hr_locations hrloc
3990: where aptax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'
3991: and aptax.global_attribute1 = to_char(hrloc.location_id)
3992: ) tax_id_values_and_codes,
3993: zx_rates_b zxrb

Line 4058: AP_TAX_CODES_ALL codes,

4054: report_codes.REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE ,
4055: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
4056: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
4057: FROM
4058: AP_TAX_CODES_ALL codes,
4059: HR_LOCATIONS hrloc,
4060: ZX_RATES_B rates,
4061: ZX_REPORTING_TYPES_B reporting_types,
4062: ZX_REPORTING_CODES_B report_codes

Line 7365: AP_TAX_CODES_ALL codes,

7361: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7362: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
7363: 1
7364: FROM
7365: AP_TAX_CODES_ALL codes,
7366: ZX_REPORTING_TYPES_B reporting_types,
7367: ZX_REPORTING_CODES_B report_codes,
7368: ZX_RATES_B rates,
7369: -- Bug 7620818