APPS.JL_ZZ_AP_LIBRARY_1_PKG dependencies on AP_TAX_CODES

Line 224: from ap_tax_codes

220: Begin
221: errcd := 0;
222: select tax_code_combination_id
223: Into ccid
224: from ap_tax_codes
225: where name = tax_name
226: and nvl(start_date,p_val_date) <= p_val_date
227: and nvl(inactive_date,p_val_date+1) > p_val_date
228: and nvl(enabled_flag,'Y') = 'Y';

Line 523: from ap_tax_codes ATC, gl_code_combinations GL

519: to_number(substr(ATC.global_attribute1,1,15)),
520: ATC.description,
521: decode(GL.account_type,'A','Y','N')
522: into tcc_id1, tcc_id2, description, account_type
523: from ap_tax_codes ATC, gl_code_combinations GL
524: where ATC.name = vatcode
525: and ATC.tax_code_combination_id = GL.code_combination_id
526: and nvl(ATC.inactive_date,sysdate + 1) > sysdate and rownum = row_number;
527: If Nvl(Tax_Reco_flg,'N') = 'Y' Then

Line 638: from ap_tax_codes

634: Begin
635: errcd := 0;
636: select substr(global_attribute2,1,25)
637: into tax_type
638: from ap_tax_codes
639: where tax_id = tax_code_id
640: and nvl(inactive_date,sysdate + 1) > sysdate and rownum = row_number;
641: Exception
642: When Others Then

Line 819: from AP_TAX_CODES

815: Begin
816:
817: select tax_id
818: into p_tax_id
819: from AP_TAX_CODES
820: where name = p_tax_name
821: and nvl(start_date,p_val_date) <= p_val_date
822: and nvl(inactive_date,p_val_date+1) > p_val_date
823: and nvl(enabled_flag,'Y') = 'Y';