APPS.OKC_REP_UPD_CON_ADMIN_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 158: FROM hr_all_organization_units

154: WHERE party_id = p_cust_id;
155:
156: CURSOR ou_name_csr IS
157: SELECT name
158: FROM hr_all_organization_units
159: WHERE organization_id = p_org_id;
160:
161: CURSOR salesperson_name_csr IS
162: SELECT jtf_res.resource_name

Line 182: l_ou_name hr_all_organization_units.name%TYPE;

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;
186: l_con_admin_name per_all_people_f.full_name%TYPE;

Line 423: hr_all_organization_units_tl hr

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'
425: AND header.header_id = t.document_id
426: AND header.sold_to_org_id = hzc.cust_account_id (+)
427: AND hzc.party_id = customer.party_id (+)

Line 453: hr_all_organization_units_tl hr

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'
455: AND header.header_id = t.document_id
456: AND header.sold_to_org_id = hzc.cust_account_id (+)
457: AND hzc.party_id = customer.party_id (+)

Line 483: hr_all_organization_units_tl hr

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'
485: AND header.quote_header_id = t.document_id
486: AND header.max_version_flag = 'Y'
487: AND (p_cust_id IS NULL OR header.cust_party_id = p_cust_id)

Line 513: Hr_all_organization_units_tl hr,

509: doc_type_tl.name AS document_type,
510: hr.name AS operating_unit,
511: header.owner_id AS contract_admin_id
512: FROM okc_rep_contracts header,
513: Hr_all_organization_units_tl hr,
514: Okc_bus_doc_types_b doc_type_b,
515: Okc_bus_doc_types_tl doc_type_tl
516: WHERE (p_cust_id IS NULL OR EXISTS (
517: SELECT con_parties.party_id