DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 1494: FROM zx_input_classifications_v

1490: WHERE (( tax_classification_code IS NOT NULL
1491: AND NOT EXISTS
1492: (
1493: SELECT 1
1494: FROM zx_input_classifications_v
1495: WHERE enabled_flag = 'Y'
1496: AND SYSDATE BETWEEN start_date_active
1497: AND NVL(end_date_active,SYSDATE)
1498: AND lookup_code = ptp_int.tax_classification_code

Line 1514: FROM zx_input_classifications_v

1510: AND tax_classification_name IS NOT NULL
1511: AND NOT EXISTS
1512: (
1513: SELECT 1
1514: FROM zx_input_classifications_v
1515: WHERE enabled_flag = 'Y'
1516: AND SYSDATE BETWEEN start_date_active
1517: AND NVL(end_date_active,SYSDATE)
1518: AND meaning = ptp_int.tax_classification_name

Line 1541: FROM zx_input_classifications_v

1537: -- value to id conversion for rounding_rule_code
1538: UPDATE zx_party_tax_profile_int ptp_int
1539: SET tax_classification_code = (
1540: SELECT lookup_code
1541: FROM zx_input_classifications_v
1542: WHERE enabled_flag = 'Y'
1543: AND SYSDATE BETWEEN start_date_active
1544: AND NVL(end_date_active,SYSDATE)
1545: AND meaning = ptp_int.tax_classification_name