APPS.OKC_REP_UPD_CON_ADMIN_PVT dependencies on HZ_PARTIES

Line 153: FROM hz_parties

149: AND lookup_type = 'OKC_REP_DOC_TYPE_GROUPS';
150:
151: CURSOR customer_name_csr IS
152: SELECT party_name
153: FROM hz_parties
154: WHERE party_id = p_cust_id;
155:
156: CURSOR ou_name_csr IS
157: SELECT name

Line 181: l_cust_name hz_parties.party_name%TYPE;

177: WHERE group_id = p_sales_group_id
178: AND language = userenv('LANG');
179:
180: l_doc_type_name okc_bus_doc_types_tl.name%TYPE;
181: l_cust_name hz_parties.party_name%TYPE;
182: l_ou_name hr_all_organization_units.name%TYPE;
183: l_salesperson_name jtf_rs_salesreps.name%TYPE;
184: l_trans_type_name oe_transaction_types_tl.name%TYPE;
185: l_sales_grp_name jtf_rs_groups_tl.group_name%TYPE;

Line 420: hz_parties customer,

416: hr.name AS operating_unit,
417: t.contract_admin_id AS contract_admin_id
418: FROM oe_blanket_headers header,
419: okc_template_usages t,
420: hz_parties customer,
421: hz_cust_accounts hzc,
422: okc_bus_doc_types_tl doc_type,
423: hr_all_organization_units_tl hr
424: WHERE t.document_type = 'B'

Line 450: hz_parties customer,

446: hr.name AS operating_unit,
447: t.contract_admin_id AS contract_admin_id
448: FROM oe_order_headers header,
449: okc_template_usages t,
450: hz_parties customer,
451: hz_cust_accounts hzc,
452: okc_bus_doc_types_tl doc_type,
453: hr_all_organization_units_tl hr
454: WHERE t.document_type = 'O'

Line 480: hz_parties customer,

476: hr.name AS operating_unit,
477: t.contract_admin_id AS contract_admin_id
478: FROM aso_quote_headers header,
479: okc_template_usages t,
480: hz_parties customer,
481: okc_bus_doc_types_tl doc_type,
482: aso_quote_statuses_vl quote_status,
483: hr_all_organization_units_tl hr
484: WHERE t.document_type = 'QUOTE'

Line 538: hz_parties hz

534:
535: CURSOR cust_names_csr (p_contract_id IN NUMBER) IS
536: SELECT hz.party_name
537: FROM okc_rep_contract_parties con_party,
538: hz_parties hz
539: WHERE con_party.contract_id = p_contract_id
540: AND (con_party.party_role_code = 'CUSTOMER_ORG' OR
541: con_party.party_role_code = 'PARTNER_ORG')
542: AND con_party.party_id = hz.party_id;

Line 567: TYPE NamesList IS TABLE OF hz_parties.party_name%TYPE NOT NULL

563:
564: TYPE NumList IS TABLE OF okc_rep_contracts_all.contract_id%TYPE NOT NULL
565: INDEX BY PLS_INTEGER;
566:
567: TYPE NamesList IS TABLE OF hz_parties.party_name%TYPE NOT NULL
568: INDEX BY PLS_INTEGER;
569:
570: selected_bsa selected_bsa_tbl;
571: selected_so selected_so_tbl;