APPS.JE_IL_TAX_PKG dependencies on JE_IL_TAX_PKG

Line 1: PACKAGE BODY JE_IL_TAX_PKG

1: PACKAGE BODY JE_IL_TAX_PKG
2: -- $Header: jeilwhtapb.pls 120.36.12020000.7 2013/03/25 07:14:21 sakekuma ship $
3: AS
4:
5: --------------------------------------------------------------------------------

Line 10: JE_IL_TAX_PKG.IS_NUMBER(max(decode(person_last_name, ''TN'', person_first_name)),''DFN'') Deduction_File_Number,

6: -- constant for first party details
7: --------------------------------------------------------------------------------
8: C_FIRST_PARTY_QUERY VARCHAR2(8000) :=
9: 'SELECT
10: JE_IL_TAX_PKG.IS_NUMBER(max(decode(person_last_name, ''TN'', person_first_name)),''DFN'') Deduction_File_Number,
11: JE_IL_TAX_PKG.IS_NUMBER(max(decode(person_last_name, ''TM'', person_first_name)),''CTPID'') Tax_Payer_ID,
12: max(decode(q1.le_role ,''Legal Contact'',email_address,null)) Email,
13: ''96'' Type_Code,
14: :P_Manual_Rpt_Exist P_Manual,

Line 11: JE_IL_TAX_PKG.IS_NUMBER(max(decode(person_last_name, ''TM'', person_first_name)),''CTPID'') Tax_Payer_ID,

7: --------------------------------------------------------------------------------
8: C_FIRST_PARTY_QUERY VARCHAR2(8000) :=
9: 'SELECT
10: JE_IL_TAX_PKG.IS_NUMBER(max(decode(person_last_name, ''TN'', person_first_name)),''DFN'') Deduction_File_Number,
11: JE_IL_TAX_PKG.IS_NUMBER(max(decode(person_last_name, ''TM'', person_first_name)),''CTPID'') Tax_Payer_ID,
12: max(decode(q1.le_role ,''Legal Contact'',email_address,null)) Email,
13: ''96'' Type_Code,
14: :P_Manual_Rpt_Exist P_Manual,
15: :P_Comp_Rpt_Exist P_Complimentary_Rpt,

Line 1185: END JE_IL_TAX_PKG;

1181: END IF;
1182: Return Vn_Ret_Awt;
1183: End get_awt_bank_amt;
1184:
1185: END JE_IL_TAX_PKG;