APPS.HR_RO_CONTRACT_VAL dependencies on FND_LOOKUP_VALUES

Line 43: from fnd_lookup_values flv

39: and SYSDATE between ppf.effective_start_date and ppf.effective_end_date;
40:
41: cursor csr_get_status(p_security_id number) is
42: select 'x'
43: from fnd_lookup_values flv
44: where flv.lookup_type='CONTRACT_STATUS'
45: and flv.language = userenv('LANG')
46: and (flv.security_group_id = p_security_id OR flv.tag is null OR flv.tag like '%+RO%')
47: and flv.lookup_code = p_status;

Line 51: from fnd_lookup_values flv

47: and flv.lookup_code = p_status;
48:
49: cursor csr_get_type(p_security_id number) is
50: select 'x'
51: from fnd_lookup_values flv
52: where flv.lookup_type='CONTRACT_TYPE'
53: and flv.language = userenv('LANG')
54: and (flv.security_group_id = p_security_id OR flv.tag is null OR flv.tag like '%+RO%')
55: and flv.lookup_code = p_type;