DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OE_SALES_CREDIT_TYPES

Line 1341: FROM oks_k_sales_credits sc, oe_sales_credit_types sct

1337: CURSOR sales_credit_csr (l_line_id NUMBER)
1338: IS
1339: SELECT PERCENT, sc.sales_credit_type_id1, sct.quota_flag,
1340: sc.ctc_id sales_person_id, sc.sales_group_id
1341: FROM oks_k_sales_credits sc, oe_sales_credit_types sct
1342: WHERE sc.sales_credit_type_id1 = sct.sales_credit_type_id
1343: AND sc.cle_id = l_line_id;
1344:
1345: CURSOR target_sales_credit_csr (

Line 1356: FROM oks_k_sales_credits sc, oe_sales_credit_types sct

1352: )
1353: IS
1354: SELECT PERCENT, sc.sales_credit_type_id1, sct.quota_flag,
1355: sc.ctc_id sales_person_id, sc.sales_group_id
1356: FROM oks_k_sales_credits sc, oe_sales_credit_types sct
1357: WHERE sc.sales_credit_type_id1 = sct.sales_credit_type_id
1358: AND sc.cle_id = l_line_id
1359: AND PERCENT = l_percent
1360: AND sc.sales_credit_type_id1 = l_sales_credit_type_id1