DBA Data[Home] [Help]

APPS.IGI_CIS_UPDC dependencies on IGI_CIS_CERT_NI_NUMBERS

Line 169: FROM igi_cis_cert_ni_numbers

165: AND certificate_type = p_current_certificate_type ;
166:
167: CURSOR c1 ( c_tax_rate_id number )IS
168: SELECT tax_rate_id , ni_number
169: FROM igi_cis_cert_ni_numbers
170: WHERE TAX_RATE_ID = c_tax_rate_id ;
171:
172:
173: CURSOR c2 (c_start_date date, c_end_date date , c_vendor_id number , c_tax_rate_id number ) is

Line 469: /* table handler for igi_cis_cert_ni_numbers_all */

465: FETCH c1 INTO l1;
466: CLOSE c1;
467: l_call_seq := 'CIS :Update Certificate Percentages' ;
468:
469: /* table handler for igi_cis_cert_ni_numbers_all */
470:
471: igi_cis_cert_ni_numbers_pkg.insert_row
472: (l_row_id
473: ,l_org_id /* Bug 3085887 11.5.10 MOAC change */

Line 471: igi_cis_cert_ni_numbers_pkg.insert_row

467: l_call_seq := 'CIS :Update Certificate Percentages' ;
468:
469: /* table handler for igi_cis_cert_ni_numbers_all */
470:
471: igi_cis_cert_ni_numbers_pkg.insert_row
472: (l_row_id
473: ,l_org_id /* Bug 3085887 11.5.10 MOAC change */
474: ,l_tax_rate_id
475: ,l1.ni_number