DBA Data[Home] [Help]

APPS.UMX_USERNAME_POLICY_PVT dependencies on FND_LOOKUPS

Line 135: from fnd_lookups

131: x_hint out nocopy FND_LOOKUP_VALUES.MEANING%TYPE) is
132:
133: cursor getPolicyDesc (p_lookup_type in varchar2) is
134: select lookup_code, meaning
135: from fnd_lookups
136: where lookup_type = p_lookup_type
137: and lookup_code in ('DESCRIPTION', 'PROMPT', 'HINT')
138: and enabled_flag = 'Y'
139: and start_date_active < sysdate

Line 144: from fnd_lookups

140: and nvl (end_date_active, sysdate + 1) > sysdate;
141:
142: cursor get_none_policy_prompt is
143: select meaning
144: from fnd_lookups
145: where lookup_type = 'UMX_USERNAME_POLICY:NONE'
146: and lookup_code = 'PROMPT'
147: and enabled_flag = 'Y'
148: and start_date_active < sysdate