APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKC_CONTACTS

Line 1147: OKC_CONTACTS con

1143: SELECT con.object1_id1
1144: FROM OKC_K_HEADERS_B CHR,
1145: OKC_CONTACT_SOURCES cso,
1146: OKC_K_PARTY_ROLES_B kpr,
1147: OKC_CONTACTS con
1148: WHERE CHR.id = cp_chr_id
1149: AND cso.cro_code = 'SALESPERSON'
1150: AND cso.rle_code = 'LESSOR'
1151: AND cso.buy_or_sell = CHR.buy_or_sell

Line 1176: l_sales_person_id OKC_CONTACTS_V.OBJECT1_ID1%TYPE;

1172: SELECT bill_to_site_use_id
1173: FROM OKC_K_HEADERS_B
1174: WHERE id = p_chr_id;
1175:
1176: l_sales_person_id OKC_CONTACTS_V.OBJECT1_ID1%TYPE;
1177: l_counter NUMBER := 1;
1178: l_org_id NUMBER;
1179: l_receivables_trx_type VARCHAR2(2000);
1180: l_bill_to_site VARCHAR2(2000);