APPS.OKL_LEASE_OPPORTUNITY_PVT dependencies on OKL_LEASE_OPPORTUNITIES_B

Line 22: FROM okl_lease_opportunities_b

18: l_db_lease_opp_rec lease_opp_rec_type;
19:
20: CURSOR chk_uniquness (p_reference_number VARCHAR2) IS
21: SELECT '1'
22: FROM okl_lease_opportunities_b
23: WHERE reference_number = p_reference_number
24: AND id <> NVL(p_lease_opp_rec.id, -9999);
25:
26: l_refno_unq_chk NUMBER;

Line 540: from Okl_lease_opportunities_b

536: l_lopv_rec.status := 'CANCELLED';
537:
538: Select object_version_number
539: into l_lopv_rec.object_version_number
540: from Okl_lease_opportunities_b
541: where id = p_lease_opp_id;
542:
543: update_lease_opp (p_api_version => p_api_version
544: ,p_init_msg_list => p_init_msg_list

Line 648: SELECT okl_util.get_next_seq_num('OKL_LOP_REF_SEQ','OKL_LEASE_OPPORTUNITIES_B','REFERENCE_NUMBER') FROM DUAL;--Bug 7022258-Modified by kkorrapo

644: FROM okl_property_tax_setups
645: WHERE org_id = mo_global.get_current_org_id();
646:
647: CURSOR c_reference_number IS
648: SELECT okl_util.get_next_seq_num('OKL_LOP_REF_SEQ','OKL_LEASE_OPPORTUNITIES_B','REFERENCE_NUMBER') FROM DUAL;--Bug 7022258-Modified by kkorrapo
649:
650: CURSOR c_sales_rep_dflts IS
651: SELECT rep.salesrep_id sales_rep_id
652: ,rep.name sales_rep_name

Line 663: AND application_table_name = 'OKL_LEASE_OPPORTUNITIES_B'

659: CURSOR c_dff_name IS
660: SELECT descriptive_flexfield_name
661: FROM fnd_descriptive_flexs
662: WHERE table_application_id = 540
663: AND application_table_name = 'OKL_LEASE_OPPORTUNITIES_B'
664: AND context_column_name = 'ATTRIBUTE_CATEGORY'
665: AND freeze_flex_definition_flag = 'Y';
666:
667: BEGIN