APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKC_CONTACTS

Line 1037: OKC_CONTACTS con

1033: SELECT con.object1_id1
1034: FROM OKC_K_HEADERS_B CHR,
1035: OKC_CONTACT_SOURCES cso,
1036: OKC_K_PARTY_ROLES_B kpr,
1037: OKC_CONTACTS con
1038: WHERE CHR.id = cp_chr_id
1039: AND cso.cro_code = 'SALESPERSON'
1040: AND cso.rle_code = 'LESSOR'
1041: AND cso.buy_or_sell = CHR.buy_or_sell

Line 1066: l_sales_person_id OKC_CONTACTS_V.OBJECT1_ID1%TYPE;

1062: SELECT bill_to_site_use_id
1063: FROM OKC_K_HEADERS_B
1064: WHERE id = p_chr_id;
1065:
1066: l_sales_person_id OKC_CONTACTS_V.OBJECT1_ID1%TYPE;
1067: l_counter NUMBER := 1;
1068: l_org_id NUMBER;
1069: l_receivables_trx_type VARCHAR2(2000);
1070: l_bill_to_site VARCHAR2(2000);