44: -- and user levels (10001/10002/10004)
45: --
46: cursor value_uas(pid number, aid number, lid number, lval number) is
47: select profile_option_value
48: from fnd_profile_option_values
49: where profile_option_id = pid
50: and application_id = aid
51: and level_id = lid
52: and level_value = lval;
56: -- level (10003)
57: --
58: cursor value_resp(pid number, aid number, lval number, laid number) is
59: select profile_option_value
60: from fnd_profile_option_values
61: where profile_option_id = pid
62: and application_id = aid
63: and level_id = 10003
64: and level_value = lval