DBA Data[Home] [Help]

APPS.OKL_VP_ASSOCIATIONS_PVT dependencies on OKL_VP_ASSOCIATIONS_V

Line 299: okl_vp_associations_v vpa

295: CURSOR get_la_assoc_chr_rec(cp_chr_id IN NUMBER, -- cp_appl_type IN VARCHAR2,
296: cp_credit_class IN VARCHAR2, cp_credit_review IN VARCHAR2, cp_sic_code IN VARCHAR2)IS
297: SELECT 'X'
298: FROM OKL_LEASEAPP_TMPLS lat,
299: okl_vp_associations_v vpa
300: WHERE lat.id = vpa.assoc_object_id
301: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
302: AND vpa.chr_id = cp_chr_id
303: AND lat.cust_credit_classification = cp_credit_class

Line 312: okl_vp_associations_v vpa

308: CURSOR get_la_assoc_crs_rec(cp_crs_id IN NUMBER, -- cp_appl_type IN VARCHAR2,
309: cp_credit_class IN VARCHAR2, cp_credit_review IN VARCHAR2, cp_sic_code IN VARCHAR2)IS
310: SELECT 'X'
311: FROM OKL_LEASEAPP_TMPLS lat,
312: okl_vp_associations_v vpa
313: WHERE lat.id = vpa.assoc_object_id
314: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
315: AND vpa.crs_id = cp_crs_id
316: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE