APPS.PER_RO_MEDICAL_ASSESSMENT dependencies on FND_LOOKUP_VALUES

Line 8: from fnd_lookup_values flv

4: g_package VARCHAR2(30) := 'PER_RO_MEDICAL_ASSESSMENT.';
5:
6: /*cursor csr_get_owner(p_security_id number,p_consultation_type_result varchar2,p_lookup_type varchar2) is
7: select flv.last_updated_by upd
8: from fnd_lookup_values flv
9: where flv.lookup_type= p_lookup_type
10: and flv.language = userenv('LANG')
11: and flv.security_group_id =p_security_id
12: and flv.lookup_code = p_consultation_type_result;

Line 17: from fnd_lookup_values flv

13:
14:
15: cursor csr_get_owner_std(p_security_id number,p_consultation_type_result varchar2,p_lookup_type varchar2) is
16: select flv.last_updated_by upd
17: from fnd_lookup_values flv
18: where flv.lookup_type= p_lookup_type
19: and flv.language = userenv('LANG')
20: and flv.security_group_id =p_security_id
21: and flv.lookup_code = p_consultation_type_result; */

Line 25: FROM fnd_lookup_values

21: and flv.lookup_code = p_consultation_type_result; */
22:
23: cursor csr_get_lookup_code(p_lookup_type varchar2,p_tag varchar2) is
24: SELECT lookup_code
25: FROM fnd_lookup_values
26: WHERE lookup_type = p_lookup_type
27: AND tag = p_tag
28: AND language = userenv ('LANG');
29: