APPS.IGI_CIS2007_IGIPSUPR_PKG dependencies on IGI_CIS2007_IGIPSUPR_PKG

Line 1: PACKAGE BODY igi_cis2007_igipsupr_pkg AS

1: PACKAGE BODY igi_cis2007_igipsupr_pkg AS
2: -- $Header: igipsupb.pls 120.1.12020000.1 2012/06/27 11:04:53 appldev ship $
3:
4: FUNCTION beforereport RETURN BOOLEAN IS
5: BEGIN

Line 10: AND nvl(IGI_CIS2007_IGIPSUPR_PKG.check_active(tax_codes.START_DATE,tax_codes.inactive_date),''A'') = ''A''

6: pwhereclause := ' grp.group_id (+) = pov.awt_group_id
7: AND grp_tax.group_id (+) = grp.group_id
8: AND tax_codes.name (+) = grp_tax.tax_name
9: AND tax_codes.enabled_flag (+) = ''Y''
10: AND nvl(IGI_CIS2007_IGIPSUPR_PKG.check_active(tax_codes.START_DATE,tax_codes.inactive_date),''A'') = ''A''
11: AND tax.tax_name (+) = tax_codes.name
12: AND nvl(tax.rate_type,''X'') NOT IN (''CERTIFICATE'',''EXCEPTION'')
13: AND nvl(IGI_CIS2007_IGIPSUPR_PKG.check_active(tax.START_DATE,
14: tax.END_DATE),''A'') = ''A''

Line 13: AND nvl(IGI_CIS2007_IGIPSUPR_PKG.check_active(tax.START_DATE,

9: AND tax_codes.enabled_flag (+) = ''Y''
10: AND nvl(IGI_CIS2007_IGIPSUPR_PKG.check_active(tax_codes.START_DATE,tax_codes.inactive_date),''A'') = ''A''
11: AND tax.tax_name (+) = tax_codes.name
12: AND nvl(tax.rate_type,''X'') NOT IN (''CERTIFICATE'',''EXCEPTION'')
13: AND nvl(IGI_CIS2007_IGIPSUPR_PKG.check_active(tax.START_DATE,
14: tax.END_DATE),''A'') = ''A''
15: AND pov.cis_enabled_flag = ''Y''';
16:
17: -- Changes made by arvind on 15-09-2006

Line 39: ' AND IGI_CIS2007_IGIPSUPR_PKG.check_active(pov.START_DATE_ACTIVE,

35: END IF;
36:
37: IF (p_active IS NOT NULL) THEN
38: pwhereclause := pwhereclause ||
39: ' AND IGI_CIS2007_IGIPSUPR_PKG.check_active(pov.START_DATE_ACTIVE,
40: pov.END_DATE_ACTIVE) = ' || '''' ||
41: p_active || '''';
42: END IF;
43:

Line 450: END igi_cis2007_igipsupr_pkg;

446: return verification_status(l_vendor_id);
447:
448: END igi_cis_is_verify_required;
449:
450: END igi_cis2007_igipsupr_pkg;