DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKS_K_SALES_CREDITS_V

Line 2942: FROM oks_k_sales_credits_v

2938: -- added cursor for sales_credit -govind
2939: CURSOR l_sales_credit_csr (p_cle_id NUMBER)
2940: IS
2941: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
2942: FROM oks_k_sales_credits_v
2943: WHERE cle_id = p_cle_id;
2944:
2945: CURSOR l_rel_csr (
2946: p_line_id NUMBER,

Line 2967: FROM oks_k_sales_credits_v

2963: --mmadhavi bug 4174921
2964: CURSOR l_sales_credit_hdr_csr (p_chr_id NUMBER)
2965: IS
2966: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
2967: FROM oks_k_sales_credits_v
2968: WHERE chr_id = p_chr_id AND cle_id IS NULL;
2969:
2970: --mmadhavi bug 4174921
2971: p_line_id NUMBER;

Line 4634: FROM oks_k_sales_credits_v

4630: CURSOR scredit_csr
4631: IS
4632: SELECT PERCENT, ctc_id, sales_credit_type_id1,
4633: sales_credit_type_id2, sales_group_id
4634: FROM oks_k_sales_credits_v
4635: WHERE chr_id = p_header_id AND cle_id IS NULL;
4636:
4637: l_scr_rec scredit_csr%ROWTYPE;
4638: l_scrv_tbl_in oks_sales_credit_pub.scrv_tbl_type;