DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKS_K_SALES_CREDITS_V

Line 2896: FROM oks_k_sales_credits_v

2892: -- added cursor for sales_credit -govind
2893: CURSOR l_sales_credit_csr (p_cle_id NUMBER)
2894: IS
2895: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
2896: FROM oks_k_sales_credits_v
2897: WHERE cle_id = p_cle_id;
2898:
2899: CURSOR l_rel_csr (
2900: p_line_id NUMBER,

Line 2921: FROM oks_k_sales_credits_v

2917: --mmadhavi bug 4174921
2918: CURSOR l_sales_credit_hdr_csr (p_chr_id NUMBER)
2919: IS
2920: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
2921: FROM oks_k_sales_credits_v
2922: WHERE chr_id = p_chr_id AND cle_id IS NULL;
2923:
2924: --mmadhavi bug 4174921
2925: p_line_id NUMBER;

Line 4588: FROM oks_k_sales_credits_v

4584: CURSOR scredit_csr
4585: IS
4586: SELECT PERCENT, ctc_id, sales_credit_type_id1,
4587: sales_credit_type_id2, sales_group_id
4588: FROM oks_k_sales_credits_v
4589: WHERE chr_id = p_header_id AND cle_id IS NULL;
4590:
4591: l_scr_rec scredit_csr%ROWTYPE;
4592: l_scrv_tbl_in oks_sales_credit_pub.scrv_tbl_type;