APPS.ZX_TAX_RECOVERY_PKG dependencies on AP_TAX_RECVRY_RATES_ALL

Line 426: l_rec_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;

422: p_tax_date IN DATE default SYSDATE,
423: p_vendorclass in po_vendors.vendor_type_lookup_code%TYPE,
424: p_concatenate in VARCHAR2) RETURN NUMBER IS
425:
426: l_rec_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
427: l_procedure ap_tax_recvry_rates_all.function%TYPE;
428: p_rate NUMBER;
429: return_val NUMBER;
430: cid NUMBER;

Line 427: l_procedure ap_tax_recvry_rates_all.function%TYPE;

423: p_vendorclass in po_vendors.vendor_type_lookup_code%TYPE,
424: p_concatenate in VARCHAR2) RETURN NUMBER IS
425:
426: l_rec_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
427: l_procedure ap_tax_recvry_rates_all.function%TYPE;
428: p_rate NUMBER;
429: return_val NUMBER;
430: cid NUMBER;
431: sql_string varchar2(255);

Line 433: l_concatenated_segment_low ap_tax_recvry_rates_all.concatenated_segment_low%type;

429: return_val NUMBER;
430: cid NUMBER;
431: sql_string varchar2(255);
432: -- l_curr_calling_sequence varchar2(2000);
433: l_concatenated_segment_low ap_tax_recvry_rates_all.concatenated_segment_low%type;
434: l_concatenated_segment_high ap_tax_recvry_rates_all.concatenated_segment_high%type;
435:
436:
437: --REM--To get the Recovery Rate if the start and end dates are specified

Line 434: l_concatenated_segment_high ap_tax_recvry_rates_all.concatenated_segment_high%type;

430: cid NUMBER;
431: sql_string varchar2(255);
432: -- l_curr_calling_sequence varchar2(2000);
433: l_concatenated_segment_low ap_tax_recvry_rates_all.concatenated_segment_low%type;
434: l_concatenated_segment_high ap_tax_recvry_rates_all.concatenated_segment_high%type;
435:
436:
437: --REM--To get the Recovery Rate if the start and end dates are specified
438: -- BUG 2576240 Replace Sysdate with p_tax_date to allow comparison to succeed

Line 443: FROM ap_tax_recvry_rates_all tr

439:
440: CURSOR c_recovery_rate_cond_null IS
441: SELECT tr.recovery_rate,tr.function,
442: tr.concatenated_segment_low,tr.concatenated_segment_high
443: FROM ap_tax_recvry_rates_all tr
444: WHERE tr.rule_id = p_rule
445: AND p_tax_date BETWEEN tr.start_date AND nvl(tr.end_date,p_tax_date+ 1)
446: AND tr.enabled_flag = 'Y'
447: AND tr.condition_value IS NULL;

Line 453: FROM ap_tax_recvry_rates_all tr

449:
450: CURSOR c_recovery_rate_cond_notnull IS
451: SELECT tr.recovery_rate,tr.function,
452: tr.concatenated_segment_low,tr.concatenated_segment_high
453: FROM ap_tax_recvry_rates_all tr
454: WHERE tr.rule_id = p_rule
455: AND p_tax_date BETWEEN tr.start_date AND nvl(tr.end_date,p_tax_date+ 1)
456: AND tr.enabled_flag = 'Y'
457: AND tr.condition_value = p_vendorclass;

Line 649: l_tax_rule_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;

645: l_rec_rate NUMBER;
646: l_tax_code_id NUMBER ;
647: -- == l_non_rec_tax_flag financials_system_params_all.non_recoverable_tax_flag%TYPE;
648: -- == l_tax_from_po_flag ap_system_parameters_all.tax_from_po_flag%TYPE;
649: l_tax_rule_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
650: lp_concatenate varchar2(2000);
651: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;
652: l_tax_type ap_tax_codes_all.tax_type%type;
653: l_get_rule_rate NUMBER;