DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OE_SALES_CREDIT_TYPES

Line 1381: FROM oks_k_sales_credits sc, oe_sales_credit_types sct

1377: CURSOR sales_credit_csr (l_line_id NUMBER)
1378: IS
1379: SELECT PERCENT, sc.sales_credit_type_id1, sct.quota_flag,
1380: sc.ctc_id sales_person_id, sc.sales_group_id
1381: FROM oks_k_sales_credits sc, oe_sales_credit_types sct
1382: WHERE sc.sales_credit_type_id1 = sct.sales_credit_type_id
1383: AND sc.cle_id = l_line_id;
1384:
1385: CURSOR target_sales_credit_csr (

Line 1396: FROM oks_k_sales_credits sc, oe_sales_credit_types sct

1392: )
1393: IS
1394: SELECT PERCENT, sc.sales_credit_type_id1, sct.quota_flag,
1395: sc.ctc_id sales_person_id, sc.sales_group_id
1396: FROM oks_k_sales_credits sc, oe_sales_credit_types sct
1397: WHERE sc.sales_credit_type_id1 = sct.sales_credit_type_id
1398: AND sc.cle_id = l_line_id
1399: AND PERCENT = l_percent
1400: AND sc.sales_credit_type_id1 = l_sales_credit_type_id1