DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_PERIOD_QUOTAS_ALL

Line 3823: FROM cn_period_quotas_all pq

3819: FUNCTION get_pq_itd_target ( p_period_id NUMBER,
3820: p_quota_id NUMBER ) RETURN NUMBER IS
3821: CURSOR l_itd_target_csr IS
3822: SELECT pq.itd_target
3823: FROM cn_period_quotas_all pq
3824: WHERE pq.period_id = p_period_id
3825: AND pq.quota_id = p_quota_id;
3826:
3827: x_itd_target NUMBER := 0;

Line 3863: FROM cn_period_quotas_all pq

3859: FUNCTION get_pq_itd_payment ( p_period_id NUMBER,
3860: p_quota_id NUMBER ) RETURN NUMBER IS
3861: CURSOR l_itd_payment_csr IS
3862: SELECT pq.itd_payment
3863: FROM cn_period_quotas_all pq
3864: WHERE pq.period_id = p_period_id
3865: AND pq.quota_id = p_quota_id;
3866:
3867: x_itd_payment NUMBER := 0;