DBA Data[Home] [Help]

APPS.XTR_LIMITS_P dependencies on XTR_DEALER_LIMITS

Line 1359: from XTR_DEALER_LIMITS

1355: --
1356: cursor c_get_limit (pc2_dealer_code VARCHAR2,pc2_deal_type VARCHAR2,
1357: pc2_product_type VARCHAR2) is
1358: select single_deal_limit_amount,authorised
1359: from XTR_DEALER_LIMITS
1360: where dealer_code = pc2_dealer_code
1361: and deal_type = pc2_deal_type
1362: and (product_type = pc2_product_type or product_type is NULL)
1363: order by product_type;

Line 1431: v_auth XTR_DEALER_LIMITS.authorised%TYPE;

1427: from XTR_pro_param
1428: where param_name = pc3_param_name;
1429: --
1430: v_ok_to_do VARCHAR2(2);
1431: v_auth XTR_DEALER_LIMITS.authorised%TYPE;
1432: v_used_amt XTR_MIRROR_DDA_LIMIT_ROW.utilised_amount%TYPE;
1433: begin
1434: -- this is not called at this stage
1435: null;