APPS.PER_GB_DISABILITY dependencies on FND_LOOKUP_VALUES

Line 23: from fnd_lookup_values flv

19:
20:
21: cursor csr_get_owner(p_security_id number) is
22: select flv.last_updated_by upd
23: from fnd_lookup_values flv
24: where flv.lookup_type='DISABILITY_CATEGORY'
25: and flv.language = userenv('LANG')
26: and flv.security_group_id = p_security_id
27: and flv.lookup_code = p_category;

Line 31: from fnd_lookup_values flv

27: and flv.lookup_code = p_category;
28:
29: cursor csr_get_owner_std(p_security_id number) is
30: select flv.last_updated_by upd
31: from fnd_lookup_values flv
32: where flv.lookup_type='DISABILITY_CATEGORY'
33: and flv.language = userenv('LANG')
34: and flv.security_group_id =p_security_id
35: and flv.lookup_code = p_category;

Line 90: from fnd_lookup_values flv

86: --and p_effective_date between pdf.effective_start_date and pdf.effective_end_date;
87:
88: cursor csr_get_owner(p_security_id number) is
89: select flv.last_updated_by upd
90: from fnd_lookup_values flv
91: where flv.lookup_type='DISABILITY_CATEGORY'
92: and flv.language = userenv('LANG')
93: and flv.security_group_id =p_security_id
94: and flv.lookup_code = p_category;

Line 99: from fnd_lookup_values flv

95:
96:
97: cursor csr_get_owner_std(p_security_id number) is
98: select flv.last_updated_by upd
99: from fnd_lookup_values flv
100: where flv.lookup_type='DISABILITY_CATEGORY'
101: and flv.language = userenv('LANG')
102: and flv.security_group_id =p_security_id
103: and flv.lookup_code = p_category;