DBA Data[Home] [Help]

APPS.OKS_RENEW_UTIL_PVT dependencies on OKS_K_DEFAULTS_V

Line 161: FROM OKS_K_DEFAULTS_V

157: p_object_code IN VARCHAR2,
158: p_date IN DATE
159: ) IS
160: SELECT payment_terms_id1, payment_terms_id2
161: FROM OKS_K_DEFAULTS_V
162: WHERE SEGMENT_ID1 = p_id1
163: AND SEGMENT_ID2 = p_id2
164: AND JTOT_OBJECT_CODE = p_object_code
165: AND CDT_TYPE = 'SDT'

Line 172: FROM OKS_K_DEFAULTS_V

168:
169: -- Cursor to fetch renewal rules defined at Global level in Global Defaults.
170: CURSOR l_global_level_cur IS
171: SELECT payment_terms_id1, payment_terms_id2
172: FROM OKS_K_DEFAULTS_V
173: WHERE cdt_type = 'MDT'
174: AND segment_id1 IS NULL
175: AND segment_id2 IS NULL
176: AND jtot_object_code IS NULL;