DBA Data[Home] [Help]

APPS.OKS_ENT_UTIL_PVT dependencies on OKS_K_HEADERS_B

Line 288: FROM OKS_K_HEADERS_B OKSCHR

284: AND RLS.JTOT_OBJECT1_CODE = 'OKX_ACCTRULE';
285: */
286: CURSOR l_acch_csr IS
287: SELECT OKSCHR.ACCT_RULE_ID
288: FROM OKS_K_HEADERS_B OKSCHR
289: WHERE OKSCHR.CHR_ID = p_hdr_id;
290:
291: CURSOR l_accl_csr IS
292: SELECT OKSCLE.ACCT_RULE_ID

Line 395: FROM OKS_K_HEADERS_B OKSCHR

391: AND RL.RULE_INFORMATION_CATEGORY = 'BPF';
392: */
393: CURSOR l_bph_csr IS
394: SELECT OKSCHR.BILLING_PROFILE_ID
395: FROM OKS_K_HEADERS_B OKSCHR
396: WHERE OKSCHR.CHR_ID = p_hdr_id;
397:
398: l_bp_id Varchar2(40);
399:

Line 894: FROM OKS_K_HEADERS_B OKSCHR

890: */
891:
892: CURSOR l_tax_csr IS
893: SELECT to_char(OKSCHR.TAX_EXEMPTION_ID),OKSCHR.TAX_STATUS
894: FROM OKS_K_HEADERS_B OKSCHR
895: WHERE OKSCHR.CHR_ID = p_hdr_id;
896:
897: l_object1_id1 varchar2(40); --OKC_RULES_B.OBJECT1_ID1%TYPE;
898: l_object2_id1 varchar2(200); --OKC_RULES_B.OBJECT1_ID2%TYPE;