APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKX_CUST_SITE_USES_V

Line 556: from okx_cust_site_uses_v

552: l_oks_lines_rec cur_oks_lines%ROWTYPE;
553:
554: Cursor cur_head_cust_acct(p_object1_id1 IN NUMBER) IS
555: select cust_account_id
556: from okx_cust_site_uses_v
557: where id1=p_object1_id1;
558:
559: Cursor cur_line_cust_acct(p_cle_id IN NUMBER) IS
560: select cust_acct_id

Line 584: from okx_cust_site_uses_v

580: l_sub_line_rec cur_sub_line%ROWTYPE;
581:
582: Cursor cur_bpf_cust_acct(l_billing_profile_id IN NUMBER, l_org_id IN NUMBER) IS
583: select distinct cust_account_id
584: from okx_cust_site_uses_v
585: where id1 In
586: (
587: select bill_to_address_id1
588: from oks_billing_profiles_b

Line 674: FROM okx_cust_site_uses_v a, okx_customer_accounts_v b

670:
671: -- GET CUST ACCT --
672: CURSOR CUR_CUST_ACCT (l_object1_id1 IN NUMBER,use IN VARCHAR2) IS
673: SELECT DISTINCT b.id1, a.party_id
674: FROM okx_cust_site_uses_v a, okx_customer_accounts_v b
675: WHERE a.id1 = l_object1_id1
676: AND b.id1 = a.cust_account_id
677: AND a.site_use_code = use;
678: