APPS.OKS_CT_EVENTS_WFA dependencies on OKX_PARTIES_V

Line 116: l_party_number OKX_PARTIES_V.PARTY_NUMBER%TYPE;

112: l_cp_service_id NUMBER;
113: l_customer_product_id NUMBER;
114: -- l_event_name CS_EVENTS.NAME%TYPE;
115: l_customer_id NUMBER;
116: l_party_number OKX_PARTIES_V.PARTY_NUMBER%TYPE;
117: l_customer_name OKX_PARTIES_V.NAME%TYPE := null;
118: l_sr_summary VARCHAR2(100);
119: l_forward_to_username varchar2(30);
120: l_user_id NUMBER;

Line 117: l_customer_name OKX_PARTIES_V.NAME%TYPE := null;

113: l_customer_product_id NUMBER;
114: -- l_event_name CS_EVENTS.NAME%TYPE;
115: l_customer_id NUMBER;
116: l_party_number OKX_PARTIES_V.PARTY_NUMBER%TYPE;
117: l_customer_name OKX_PARTIES_V.NAME%TYPE := null;
118: l_sr_summary VARCHAR2(100);
119: l_forward_to_username varchar2(30);
120: l_user_id NUMBER;
121:

Line 134: okx_parties_v opv

130: select cpl.object1_id1 customer_id,opv.name customer_name,opv.party_number party_number
131: from okc_k_lines_v cle,
132: okc_k_headers_v chr,
133: okc_k_party_roles_b cpl,
134: okx_parties_v opv
135: where cle.id = l_k_line_id
136: and cle.dnz_chr_id = chr.id
137: and cpl.chr_id = chr.id
138: and cpl.cle_id is null