DBA Data[Home] [Help]

APPS.CN_IMP_RULE_PVT dependencies on CN_REVENUE_CLASSES

Line 550: CURSOR c_revenue_id_csr (l_name cn_revenue_classes.name%TYPE) IS

546: AND ruleset_id=p_ruleset_id
547: AND org_id=p_org_id;
548:
549: -- Cursor to get the revenue class id, given the revenue class name
550: CURSOR c_revenue_id_csr (l_name cn_revenue_classes.name%TYPE) IS
551: SELECT revenue_class_id
552: FROM cn_revenue_classes
553: WHERE name = l_name
554: and org_id=p_org_id;

Line 552: FROM cn_revenue_classes

548:
549: -- Cursor to get the revenue class id, given the revenue class name
550: CURSOR c_revenue_id_csr (l_name cn_revenue_classes.name%TYPE) IS
551: SELECT revenue_class_id
552: FROM cn_revenue_classes
553: WHERE name = l_name
554: and org_id=p_org_id;
555:
556: -- cursor to get the liability code id