APPS.IGI_CIS_GET_PROFILE dependencies on FND_PROFILE_OPTION_VALUES

Line 5: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;

1: PACKAGE BODY IGI_CIS_GET_PROFILE AS
2: /* $Header: igicisab.pls 115.5 2002/08/29 15:06:45 sbrewer ship $ */
3:
4: FUNCTION Cis_Tax_Code RETURN VARCHAR2 IS
5: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
6: BEGIN
7:
8: SELECT profile_option_value
9: INTO l_profile_option_value

Line 10: FROM fnd_profile_option_values fpov

6: BEGIN
7:
8: SELECT profile_option_value
9: INTO l_profile_option_value
10: FROM fnd_profile_option_values fpov
11: ,fnd_profile_options fpo
12: WHERE UPPER(fpo.profile_option_name) = 'IGI_CIS_TAX_CODE'
13: AND fpov.profile_option_id = fpo.profile_option_id
14: AND fpov.level_id = 10001;

Line 31: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;

27: RETURN l_profile_option_value;
28: END Cis_Tax_Code;
29:
30: FUNCTION Cis_Tax_Group RETURN VARCHAR2 IS
31: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
32: BEGIN
33:
34: SELECT profile_option_value
35: INTO l_profile_option_value

Line 36: FROM fnd_profile_option_values fpov

32: BEGIN
33:
34: SELECT profile_option_value
35: INTO l_profile_option_value
36: FROM fnd_profile_option_values fpov
37: ,fnd_profile_options fpo
38: WHERE UPPER(fpo.profile_option_name) = 'IGI_CIS_TAX_GROUP'
39: AND fpov.profile_option_id = fpo.profile_option_id
40: AND fpov.level_id = 10001;