APPS.OKL_LOSS_PROV_PVT dependencies on OKC_CONTACTS

Line 511: OKC_CONTACTS con

507: SELECT con.object1_id1
508: FROM OKC_K_HEADERS_B CHR,
509: OKC_CONTACT_SOURCES cso,
510: OKC_K_PARTY_ROLES_B kpr,
511: OKC_CONTACTS con
512: WHERE CHR.id = cp_chr_id
513: AND cso.cro_code = 'SALESPERSON'
514: AND cso.rle_code = 'LESSOR'
515: AND cso.buy_or_sell = CHR.buy_or_sell

Line 540: l_sales_person_id OKC_CONTACTS_V.OBJECT1_ID1%TYPE;

536: SELECT bill_to_site_use_id
537: FROM OKC_K_HEADERS_B
538: WHERE id = p_chr_id;
539:
540: l_sales_person_id OKC_CONTACTS_V.OBJECT1_ID1%TYPE;
541: l_counter NUMBER := 1;
542: l_org_id NUMBER;
543: l_receivables_trx_type VARCHAR2(2000);
544: l_bill_to_site VARCHAR2(2000);