97: where shipment_line_id = p_shipment_line_id
98: and
99: (
100: (tax_type in (
101: jai_constants.tax_type_cvd,
102: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
103: jai_constants.tax_type_customs,/*rchandan for bug#4428980*/
104: jai_constants.tax_type_customs_Edu_cess,
105: jai_constants.tax_type_cvd_edu_Cess,jai_constants.tax_type_sh_customs_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess)) /* BOE Tax Added higher education cess for bug #5907436 ; kundan kumar */
98: and
99: (
100: (tax_type in (
101: jai_constants.tax_type_cvd,
102: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
103: jai_constants.tax_type_customs,/*rchandan for bug#4428980*/
104: jai_constants.tax_type_customs_Edu_cess,
105: jai_constants.tax_type_cvd_edu_Cess,jai_constants.tax_type_sh_customs_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess)) /* BOE Tax Added higher education cess for bug #5907436 ; kundan kumar */
106: or
99: (
100: (tax_type in (
101: jai_constants.tax_type_cvd,
102: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
103: jai_constants.tax_type_customs,/*rchandan for bug#4428980*/
104: jai_constants.tax_type_customs_Edu_cess,
105: jai_constants.tax_type_cvd_edu_Cess,jai_constants.tax_type_sh_customs_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess)) /* BOE Tax Added higher education cess for bug #5907436 ; kundan kumar */
106: or
107: (tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery) /* Third party tax */--rchandan for bug#4428980
100: (tax_type in (
101: jai_constants.tax_type_cvd,
102: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
103: jai_constants.tax_type_customs,/*rchandan for bug#4428980*/
104: jai_constants.tax_type_customs_Edu_cess,
105: jai_constants.tax_type_cvd_edu_Cess,jai_constants.tax_type_sh_customs_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess)) /* BOE Tax Added higher education cess for bug #5907436 ; kundan kumar */
106: or
107: (tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery) /* Third party tax */--rchandan for bug#4428980
108: and vendor_id > 0
101: jai_constants.tax_type_cvd,
102: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
103: jai_constants.tax_type_customs,/*rchandan for bug#4428980*/
104: jai_constants.tax_type_customs_Edu_cess,
105: jai_constants.tax_type_cvd_edu_Cess,jai_constants.tax_type_sh_customs_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess)) /* BOE Tax Added higher education cess for bug #5907436 ; kundan kumar */
106: or
107: (tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery) /* Third party tax */--rchandan for bug#4428980
108: and vendor_id > 0
109: and vendor_id <> p_po_vendor_id
103: jai_constants.tax_type_customs,/*rchandan for bug#4428980*/
104: jai_constants.tax_type_customs_Edu_cess,
105: jai_constants.tax_type_cvd_edu_Cess,jai_constants.tax_type_sh_customs_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess)) /* BOE Tax Added higher education cess for bug #5907436 ; kundan kumar */
106: or
107: (tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery) /* Third party tax */--rchandan for bug#4428980
108: and vendor_id > 0
109: and vendor_id <> p_po_vendor_id
110: )
111: );
435:
436: * High Dependancy for future Versions of this object *
437:
438: --------------------------------------------------------------------------------------------*/
439: V_DEBUG := jai_constants.yes ; --Ramananda for File.Sql.35
440:
441: IF V_DEBUG ='Y' THEN
442: FND_FILE.PUT_LINE(FND_FILE.LOG,'********Start of Claiming Modvat for FA Retirement *********');
443: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.0 The Value of p_organization_id:' ||p_organization_id