DBA Data[Home] [Help]

APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKS_BILLING_PROFILES_B

Line 588: from oks_billing_profiles_b

584: from okx_cust_site_uses_v
585: where id1 In
586: (
587: select bill_to_address_id1
588: from oks_billing_profiles_b
589: where OWNED_PARTY_ID1 IS NOT NULL
590: and id = l_billing_profile_id)
591: AND site_use_code = 'BILL_TO'
592: AND org_id = l_org_id;

Line 596: from oks_billing_profiles_b

592: AND org_id = l_org_id;
593:
594: Cursor cur_bill_to_address_id1 (l_billing_profile_id IN NUMBER) IS
595: select bill_to_address_id1
596: from oks_billing_profiles_b
597: where id = l_billing_profile_id
598: AND OWNED_PARTY_ID1 IS NOT NULL;
599:
600: Cursor cur_billing_profile (l_billing_profile_id IN NUMBER) IS

Line 603: from oks_billing_profiles_b

599:
600: Cursor cur_billing_profile (l_billing_profile_id IN NUMBER) IS
601: select account_object1_id1
602: ,invoice_object1_id1
603: from oks_billing_profiles_b
604: where id = l_billing_profile_id;
605:
606: -- Bug 5191587 --
607: -- Added condition to verify Service and Extended Warranty Lines