DBA Data[Home] [Help]

APPS.IGF_DB_SF_INTEGRATION dependencies on IGF_LOOKUPS_VIEW

Line 308: FUNCTION lookup_desc( p_type IN igf_lookups_view.lookup_type%TYPE,

304:
305: END get_bill_desc;
306:
307:
308: FUNCTION lookup_desc( p_type IN igf_lookups_view.lookup_type%TYPE,
309: p_code IN igf_lookups_view.lookup_code%TYPE) RETURN VARCHAR2 IS
310: /***********************************************************************************************
311:
312: Created By : Sarakshi

Line 309: p_code IN igf_lookups_view.lookup_code%TYPE) RETURN VARCHAR2 IS

305: END get_bill_desc;
306:
307:
308: FUNCTION lookup_desc( p_type IN igf_lookups_view.lookup_type%TYPE,
309: p_code IN igf_lookups_view.lookup_code%TYPE) RETURN VARCHAR2 IS
310: /***********************************************************************************************
311:
312: Created By : Sarakshi
313: Date Created By: 24-Dec-2001

Line 910: l_log_status igf_lookups_view.meaning%TYPE;

906: l_spnsr_charge_id igf_db_awd_disb_dtl.spnsr_charge_id%TYPE := NULL;
907: l_paid_amt igf_aw_award.paid_amt%TYPE;
908: l_disb_paid_amt igf_aw_awd_disb.disb_paid_amt%TYPE;
909: l_status_code igf_db_awd_disb_dtl.sf_status%TYPE;
910: l_log_status igf_lookups_view.meaning%TYPE;
911: l_flag1 BOOLEAN :=TRUE;
912: l_flag2 BOOLEAN :=TRUE;
913: l_flag3 BOOLEAN :=TRUE;
914: l_refunds BOOLEAN :=FALSE;