APPS.IGI_CIS2007_CDROM_PKG dependencies on IGI_CIS_CDROM_LINES_T

Line 342: From igi_cis_cdrom_lines_t;

338: subcontractor_name,
339: subcontractor_ref_id,
340: tax_month_last_paid,
341: tax_treatment
342: From igi_cis_cdrom_lines_t;
343:
344: Cursor C_Cnt(p_utr in igi_cis_cdrom_lines_t.subcontractor_utr%Type) Is
345: Select count(*) cnt
346: From igi_cis_cdrom_lines_t

Line 344: Cursor C_Cnt(p_utr in igi_cis_cdrom_lines_t.subcontractor_utr%Type) Is

340: tax_month_last_paid,
341: tax_treatment
342: From igi_cis_cdrom_lines_t;
343:
344: Cursor C_Cnt(p_utr in igi_cis_cdrom_lines_t.subcontractor_utr%Type) Is
345: Select count(*) cnt
346: From igi_cis_cdrom_lines_t
347: Where subcontractor_utr = p_utr;
348: Begin

Line 346: From igi_cis_cdrom_lines_t

342: From igi_cis_cdrom_lines_t;
343:
344: Cursor C_Cnt(p_utr in igi_cis_cdrom_lines_t.subcontractor_utr%Type) Is
345: Select count(*) cnt
346: From igi_cis_cdrom_lines_t
347: Where subcontractor_utr = p_utr;
348: Begin
349: For C_Igi_Cis_Cdrom_Lines_Rec In C_Igi_Cis_Cdrom_Lines Loop
350: l_match_flag := 'U';

Line 398: Update igi_cis_cdrom_lines_t

394: End If;
395: End If;
396: End If;
397: /* Updating the interface table with match flag - to generate the report */
398: Update igi_cis_cdrom_lines_t
399: Set match_flag = l_match_flag
400: Where subcontractor_utr = C_Igi_Cis_Cdrom_Lines_Rec.subcontractor_utr;
401:
402: /* if CD-ROM subcontractor matches with AP_SUPPLIERS subcontractor and user asks for Upload also */

Line 450: From igi_cis_cdrom_lines_t

446: subcontractor_name,
447: subcontractor_ref_id,
448: tax_month_last_paid,
449: tax_treatment
450: From igi_cis_cdrom_lines_t
451: Where match_flag = 'M'
452: Order by subcontractor_name;
453:
454: Cursor C_Cdrom_Unmatched_Vendors Is

Line 460: From igi_cis_cdrom_lines_t

456: subcontractor_name,
457: subcontractor_ref_id,
458: tax_month_last_paid,
459: tax_treatment
460: From igi_cis_cdrom_lines_t
461: Where match_flag = 'U'
462: Order by subcontractor_name;
463:
464: Cursor C_Vendor_Not_Found Is

Line 474: FROM ap_suppliers p, igi_cis_cdrom_lines_t l

470: From ap_suppliers
471: Where cis_enabled_flag = 'Y'
472: and vendor_id not in (
473: SELECT p.vendor_id
474: FROM ap_suppliers p, igi_cis_cdrom_lines_t l
475: WHERE (p.partnership_utr = l.subcontractor_utr
476: Or p.unique_tax_reference_num = l.subcontractor_utr)
477: And match_flag = 'M')
478: Order by vendor_name;

Line 480: Cursor C_Site_Invoice_Count(P_Utr in igi_cis_cdrom_lines_t.subcontractor_utr%Type) Is

476: Or p.unique_tax_reference_num = l.subcontractor_utr)
477: And match_flag = 'M')
478: Order by vendor_name;
479:
480: Cursor C_Site_Invoice_Count(P_Utr in igi_cis_cdrom_lines_t.subcontractor_utr%Type) Is
481: Select atr.tax_name tax_name,
482: atr.tax_rate tax_rate,
483: pvs.vendor_site_code site_code,
484: nvl(inv.inv_count,0) inv_count

Line 678: From igi_cis_cdrom_lines_t

674: l_count Number := 0;
675:
676: Cursor C_Subcontractor_UTR IS
677: Select SUBCONTRACTOR_UTR
678: From igi_cis_cdrom_lines_t
679: Group by SUBCONTRACTOR_UTR
680: Having count(SUBCONTRACTOR_UTR) >1;
681: Begin
682: For C_Subcontractor_UTR_Rec in C_Subcontractor_UTR Loop