[Home] [Help]
2887: CURSOR csr_get_shared_types(c_code VARCHAR2
2888: ,c_bg_id NUMBER
2889: ,c_lookup VARCHAR2) IS
2890: SELECT system_type_cd
2891: FROM per_shared_types
2892: WHERE lookup_type = c_lookup --'NL_NATIONALITY'
2893: AND information1 = c_code
2894: AND (business_group_id = c_bg_id
2895: OR business_group_id is NULL)