APPS.IGI_CIS_CI36_DATA_PKG dependencies on IGI_CIS_AWT_TAX_RATES

Line 48: CURSOR c_cis_awt_tax_rates (P_vendor_id igi_cis_awt_tax_rates.vendor_id%TYPE,

44: Ni_number
45: FROM igi_cis_ci36_payments;
46:
47: /* Modified the AND condition to include nvl check for icatr1.end_date Bug Bug#2443887 -solakshm*/
48: CURSOR c_cis_awt_tax_rates (P_vendor_id igi_cis_awt_tax_rates.vendor_id%TYPE,
49: P_vendor_site_id igi_cis_awt_tax_rates.vendor_site_id%TYPE,
50: P_check_date igi_cis_ci36_payments.Check_date%TYPE )
51: IS
52: SELECT icatr1.certificate_type , icatr1.certificate_number ,

Line 49: P_vendor_site_id igi_cis_awt_tax_rates.vendor_site_id%TYPE,

45: FROM igi_cis_ci36_payments;
46:
47: /* Modified the AND condition to include nvl check for icatr1.end_date Bug Bug#2443887 -solakshm*/
48: CURSOR c_cis_awt_tax_rates (P_vendor_id igi_cis_awt_tax_rates.vendor_id%TYPE,
49: P_vendor_site_id igi_cis_awt_tax_rates.vendor_site_id%TYPE,
50: P_check_date igi_cis_ci36_payments.Check_date%TYPE )
51: IS
52: SELECT icatr1.certificate_type , icatr1.certificate_number ,
53: Substr(icatr1.comments,1,50) "comments", icatr1.ni_number

Line 54: FROM igi_cis_awt_tax_rates icatr1

50: P_check_date igi_cis_ci36_payments.Check_date%TYPE )
51: IS
52: SELECT icatr1.certificate_type , icatr1.certificate_number ,
53: Substr(icatr1.comments,1,50) "comments", icatr1.ni_number
54: FROM igi_cis_awt_tax_rates icatr1
55: WHERE icatr1.vendor_id = P_vendor_id
56: AND icatr1.vendor_site_id = P_vendor_site_id
57: AND icatr1.tax_name = fnd_profile.value ('IGI_CIS_TAX_CODE')
58: AND TRUNC(NVL(P_check_date,icatr1.start_date))

Line 63: FROM igi_cis_awt_tax_rates icatr2

59: BETWEEN TRUNC(icatr1.start_date)
60: AND nvl(TRUNC(icatr1.end_date),to_date('9999/12/31','YYYY/MM/DD'))
61: AND NVL(icatr1.priority, '-1') =
62: (SELECT NVL(MIN(icatr2.priority), '-1')
63: FROM igi_cis_awt_tax_rates icatr2
64: WHERE icatr2.vendor_id = P_vendor_id
65: AND icatr2.vendor_site_id = P_vendor_site_id
66: AND icatr2.tax_name = fnd_profile.value ('IGI_CIS_TAX_CODE')
67: AND TRUNC(NVL(P_check_date,icatr2.start_date))

Line 138: l_certificate_type igi_cis_awt_tax_rates.certificate_type%TYPE;

134: Cursor cur_log2 is
135: select count(*) from igi_cis_ci36_payments;
136:
137: l_invoice_num igi_cis_ci36_payments.invoice_num%TYPE;
138: l_certificate_type igi_cis_awt_tax_rates.certificate_type%TYPE;
139: l_certificate_number igi_cis_awt_tax_rates.certificate_number%TYPE;
140: l_certificate_description Varchar2(50);
141: l_ni_number igi_cis_awt_tax_rates.ni_number%TYPE;
142: l_return_status Number;

Line 139: l_certificate_number igi_cis_awt_tax_rates.certificate_number%TYPE;

135: select count(*) from igi_cis_ci36_payments;
136:
137: l_invoice_num igi_cis_ci36_payments.invoice_num%TYPE;
138: l_certificate_type igi_cis_awt_tax_rates.certificate_type%TYPE;
139: l_certificate_number igi_cis_awt_tax_rates.certificate_number%TYPE;
140: l_certificate_description Varchar2(50);
141: l_ni_number igi_cis_awt_tax_rates.ni_number%TYPE;
142: l_return_status Number;
143: x_low_date date;

Line 141: l_ni_number igi_cis_awt_tax_rates.ni_number%TYPE;

137: l_invoice_num igi_cis_ci36_payments.invoice_num%TYPE;
138: l_certificate_type igi_cis_awt_tax_rates.certificate_type%TYPE;
139: l_certificate_number igi_cis_awt_tax_rates.certificate_number%TYPE;
140: l_certificate_description Varchar2(50);
141: l_ni_number igi_cis_awt_tax_rates.ni_number%TYPE;
142: l_return_status Number;
143: x_low_date date;
144: x_high_date date;
145: l_count1 Number := 0;