APPS.ZX_TAX_RECOVERY_PKG dependencies on AP_TAX_RECVRY_RATES_ALL

Line 412: l_rec_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;

408: p_tax_date IN DATE default SYSDATE,
409: p_vendorclass in po_vendors.vendor_type_lookup_code%TYPE,
410: p_concatenate in VARCHAR2) RETURN NUMBER IS
411:
412: l_rec_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
413: l_procedure ap_tax_recvry_rates_all.function%TYPE;
414: p_rate NUMBER;
415: return_val NUMBER;
416: cid NUMBER;

Line 413: l_procedure ap_tax_recvry_rates_all.function%TYPE;

409: p_vendorclass in po_vendors.vendor_type_lookup_code%TYPE,
410: p_concatenate in VARCHAR2) RETURN NUMBER IS
411:
412: l_rec_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
413: l_procedure ap_tax_recvry_rates_all.function%TYPE;
414: p_rate NUMBER;
415: return_val NUMBER;
416: cid NUMBER;
417: sql_string varchar2(255);

Line 419: l_concatenated_segment_low ap_tax_recvry_rates_all.concatenated_segment_low%type;

415: return_val NUMBER;
416: cid NUMBER;
417: sql_string varchar2(255);
418: -- l_curr_calling_sequence varchar2(2000);
419: l_concatenated_segment_low ap_tax_recvry_rates_all.concatenated_segment_low%type;
420: l_concatenated_segment_high ap_tax_recvry_rates_all.concatenated_segment_high%type;
421:
422:
423: --REM--To get the Recovery Rate if the start and end dates are specified

Line 420: l_concatenated_segment_high ap_tax_recvry_rates_all.concatenated_segment_high%type;

416: cid NUMBER;
417: sql_string varchar2(255);
418: -- l_curr_calling_sequence varchar2(2000);
419: l_concatenated_segment_low ap_tax_recvry_rates_all.concatenated_segment_low%type;
420: l_concatenated_segment_high ap_tax_recvry_rates_all.concatenated_segment_high%type;
421:
422:
423: --REM--To get the Recovery Rate if the start and end dates are specified
424: -- BUG 2576240 Replace Sysdate with p_tax_date to allow comparison to succeed

Line 429: FROM ap_tax_recvry_rates_all tr

425:
426: CURSOR c_recovery_rate_cond_null IS
427: SELECT tr.recovery_rate,tr.function,
428: tr.concatenated_segment_low,tr.concatenated_segment_high
429: FROM ap_tax_recvry_rates_all tr
430: WHERE tr.rule_id = p_rule
431: AND p_tax_date BETWEEN tr.start_date AND nvl(tr.end_date,p_tax_date+ 1)
432: AND tr.enabled_flag = 'Y'
433: AND tr.condition_value IS NULL;

Line 439: FROM ap_tax_recvry_rates_all tr

435:
436: CURSOR c_recovery_rate_cond_notnull IS
437: SELECT tr.recovery_rate,tr.function,
438: tr.concatenated_segment_low,tr.concatenated_segment_high
439: FROM ap_tax_recvry_rates_all tr
440: WHERE tr.rule_id = p_rule
441: AND p_tax_date BETWEEN tr.start_date AND nvl(tr.end_date,p_tax_date+ 1)
442: AND tr.enabled_flag = 'Y'
443: AND tr.condition_value = p_vendorclass;

Line 635: l_tax_rule_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;

631: l_rec_rate NUMBER;
632: l_tax_code_id NUMBER ;
633: -- == l_non_rec_tax_flag financials_system_params_all.non_recoverable_tax_flag%TYPE;
634: -- == l_tax_from_po_flag ap_system_parameters_all.tax_from_po_flag%TYPE;
635: l_tax_rule_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
636: lp_concatenate varchar2(2000);
637: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;
638: l_tax_type ap_tax_codes_all.tax_type%type;
639: l_get_rule_rate NUMBER;