DBA Data[Home] [Help]

APPS.PN_R12_UTIL_PKG dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 71: FROM zx_output_classifications_v

67: IS
68:
69: CURSOR csr_bill IS
70: SELECT meaning
71: FROM zx_output_classifications_v
72: WHERE enabled_flag = 'Y'
73: AND trunc(SYSDATE) BETWEEN TRUNC(nvl(start_date_active,SYSDATE)) AND TRUNC(nvl(end_date_active,SYSDATE))
74: AND org_id = p_org_id
75: AND lookup_code = p_tcc;