DBA Data[Home] [Help]

APPS.OKL_LEASE_OPPORTUNITY_PVT dependencies on MO_GLOBAL

Line 645: WHERE org_id = mo_global.get_current_org_id();

641: CURSOR c_prop_tax_dflts IS
642: SELECT property_tax_applicable,
643: bill_property_tax
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:

Line 655: WHERE rep.org_id = mo_global.get_current_org_id()

651: SELECT rep.salesrep_id sales_rep_id
652: ,rep.name sales_rep_name
653: FROM jtf_rs_salesreps rep
654: ,jtf_rs_resource_extns res
655: WHERE rep.org_id = mo_global.get_current_org_id()
656: AND rep.resource_id = res.resource_id
657: AND res.user_id = G_USER_ID;
658:
659: CURSOR c_dff_name IS