DBA Data[Home] [Help]

APPS.PN_R12_UTIL_PKG dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 79: FROM ZX_INPUT_CLASSIFICATIONS_V

75: AND lookup_code = p_tcc;
76:
77: CURSOR csr_pay IS
78: SELECT meaning
79: FROM ZX_INPUT_CLASSIFICATIONS_V
80: WHERE lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
81: AND enabled_flag = 'Y'
82: AND trunc(SYSDATE) BETWEEN TRUNC(nvl(start_date_active, SYSDATE)) AND TRUNC(nvl(end_date_active, SYSDATE))
83: AND org_id = p_org_id