APPS.OKL_QPY_PVT dependencies on JTF_OBJECTS_VL

Line 344: FROM jtf_objects_vl OB

340: p_qpyv_rec IN qpyv_rec_type) IS
341:
342: CURSOR l_jtot_csr IS
343: SELECT 'x'
344: FROM jtf_objects_vl OB
345: WHERE OB.OBJECT_CODE = p_qpyv_rec.party_jtot_object1_code;
346:
347: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
348: l_dummy_var VARCHAR2(1) := '?';

Line 372: p_token3_value => 'JTF_OBJECTS_VL');

368: p_token1_value => 'party_jtot_object1_code',
369: p_token2 => G_CHILD_TABLE_TOKEN,
370: p_token2_value => 'OKL_QUOTE_PARTIES_V',
371: p_token3 => G_PARENT_TABLE_TOKEN,
372: p_token3_value => 'JTF_OBJECTS_VL');
373:
374: -- notify caller of an error
375: x_return_status := OKC_API.G_RET_STS_ERROR;
376: END IF;

Line 416: from jtf_objects_vl OB

412:
413: cursor l_object1_csr is
414: select from_table,
415: trim(where_clause) where_clause
416: from jtf_objects_vl OB
417: where OB.OBJECT_CODE = p_qpyv_rec.party_jtot_object1_code;
418:
419: e_no_data_found EXCEPTION;
420: PRAGMA EXCEPTION_INIT(e_no_data_found,100);

Line 497: FROM jtf_objects_vl OB

493: p_qpyv_rec IN qpyv_rec_type) IS
494:
495: CURSOR l_jtot_csr IS
496: SELECT 'x'
497: FROM jtf_objects_vl OB
498: WHERE OB.OBJECT_CODE = p_qpyv_rec.contact_jtot_object1_code;
499:
500: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
501: l_dummy_var VARCHAR2(1) := '?';

Line 525: p_token3_value => 'JTF_OBJECTS_VL');

521: p_token1_value => 'contact_jtot_object1_code',
522: p_token2 => G_CHILD_TABLE_TOKEN,
523: p_token2_value => 'OKL_QUOTE_PARTIES_V',
524: p_token3 => G_PARENT_TABLE_TOKEN,
525: p_token3_value => 'JTF_OBJECTS_VL');
526:
527: -- notify caller of an error
528: x_return_status := OKC_API.G_RET_STS_ERROR;
529: END IF;

Line 569: from jtf_objects_vl OB

565:
566: cursor l_object1_csr is
567: select from_table,
568: trim(where_clause) where_clause
569: from jtf_objects_vl OB
570: where OB.OBJECT_CODE = p_qpyv_rec.contact_jtot_object1_code;
571:
572: e_no_data_found EXCEPTION;
573: PRAGMA EXCEPTION_INIT(e_no_data_found,100);