DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CREDIT_TYPES

Line 878: l_credit_type_name cn_credit_types.name%TYPE;

874: l_output_achieved NUMBER ;
875: l_perf_achieved NUMBER ;
876: l_commission_achieved NUMBER;
877:
878: l_credit_type_name cn_credit_types.name%TYPE;
879: l_start_period_id NUMBER;
880: l_end_period_id NUMBER;
881: l_interval_type_id NUMBER;
882: l_org_id NUMBER;

Line 901: cn_credit_types cr

897:
898: CURSOR l_quota_csr (l_quota_id NUMBER ) IS
899: SELECT q.incremental_type, cr.name, q.interval_type_id, q.org_id
900: FROM cn_quotas_all q,
901: cn_credit_types cr
902: WHERE q.quota_id = l_quota_id
903: AND cr.credit_type_id = q.credit_type_id
904: AND cr.org_id = q.org_id;
905: