DBA Data[Home] [Help]

APPS.IGS_FI_CRDAPI_UTIL dependencies on IGF_LOOKUPS_VIEW

Line 877: CURSOR cur_igf_lkp (cp_lookup_code igf_lookups_view.lookup_code%TYPE,

873: Known limitations,enhancements,remarks:
874: Change History
875: Who When What
876: ********************************************************************************************** */
877: CURSOR cur_igf_lkp (cp_lookup_code igf_lookups_view.lookup_code%TYPE,
878: cp_lookup_type igf_lookups_view.lookup_type%TYPE,
879: cp_enabled_flag VARCHAR2)
880: IS
881: SELECT 'x'

Line 878: cp_lookup_type igf_lookups_view.lookup_type%TYPE,

874: Change History
875: Who When What
876: ********************************************************************************************** */
877: CURSOR cur_igf_lkp (cp_lookup_code igf_lookups_view.lookup_code%TYPE,
878: cp_lookup_type igf_lookups_view.lookup_type%TYPE,
879: cp_enabled_flag VARCHAR2)
880: IS
881: SELECT 'x'
882: FROM igf_lookups_view

Line 882: FROM igf_lookups_view

878: cp_lookup_type igf_lookups_view.lookup_type%TYPE,
879: cp_enabled_flag VARCHAR2)
880: IS
881: SELECT 'x'
882: FROM igf_lookups_view
883: WHERE lookup_type = cp_lookup_type
884: AND lookup_code = cp_lookup_code
885: AND enabled_flag= cp_enabled_flag;
886: rec_igf_lkp cur_igf_lkp%ROWTYPE;