DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 1501: FROM zx_output_classifications_v

1497: AND NVL(end_date_active,SYSDATE)
1498: AND lookup_code = ptp_int.tax_classification_code
1499: UNION ALL
1500: SELECT 1
1501: FROM zx_output_classifications_v
1502: WHERE enabled_flag = 'Y'
1503: AND SYSDATE BETWEEN start_date_active
1504: AND NVL(end_date_active,SYSDATE)
1505: AND lookup_code = ptp_int.tax_classification_code

Line 1521: FROM zx_output_classifications_v

1517: AND NVL(end_date_active,SYSDATE)
1518: AND meaning = ptp_int.tax_classification_name
1519: UNION ALL
1520: SELECT 1
1521: FROM zx_output_classifications_v
1522: WHERE enabled_flag = 'Y'
1523: AND SYSDATE BETWEEN start_date_active
1524: AND NVL(end_date_active,SYSDATE)
1525: AND meaning = ptp_int.tax_classification_name

Line 1548: FROM zx_output_classifications_v

1544: AND NVL(end_date_active,SYSDATE)
1545: AND meaning = ptp_int.tax_classification_name
1546: UNION
1547: SELECT lookup_code
1548: FROM zx_output_classifications_v
1549: WHERE enabled_flag = 'Y'
1550: AND SYSDATE BETWEEN start_date_active
1551: AND NVL(end_date_active,SYSDATE)
1552: AND meaning = ptp_int.tax_classification_name