DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CREDIT_TYPES

Line 877: l_credit_type_name cn_credit_types.name%TYPE;

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

Line 900: cn_credit_types cr

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