DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_PERIOD_QUOTAS_ALL

Line 3794: FROM cn_period_quotas_all pq

3790: FUNCTION get_pq_itd_target ( p_period_id NUMBER,
3791: p_quota_id NUMBER ) RETURN NUMBER IS
3792: CURSOR l_itd_target_csr IS
3793: SELECT pq.itd_target
3794: FROM cn_period_quotas_all pq
3795: WHERE pq.period_id = p_period_id
3796: AND pq.quota_id = p_quota_id;
3797:
3798: x_itd_target NUMBER := 0;

Line 3834: FROM cn_period_quotas_all pq

3830: FUNCTION get_pq_itd_payment ( p_period_id NUMBER,
3831: p_quota_id NUMBER ) RETURN NUMBER IS
3832: CURSOR l_itd_payment_csr IS
3833: SELECT pq.itd_payment
3834: FROM cn_period_quotas_all pq
3835: WHERE pq.period_id = p_period_id
3836: AND pq.quota_id = p_quota_id;
3837:
3838: x_itd_payment NUMBER := 0;