APPS.PAY_US_USERRA dependencies on FND_COMMON_LOOKUPS

Line 24: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;

20: /************************************************************
21: ** Local Package Variables
22: ************************************************************/
23:
24: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
25: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
26: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
27: lv_balance fnd_common_lookups.meaning%TYPE := null;
28: lv_description fnd_common_lookups.description%TYPE := null;

Line 25: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;

21: ** Local Package Variables
22: ************************************************************/
23:
24: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
25: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
26: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
27: lv_balance fnd_common_lookups.meaning%TYPE := null;
28: lv_description fnd_common_lookups.description%TYPE := null;
29: ln_application_id fnd_common_lookups.application_id%TYPE := 0;

Line 26: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;

22: ************************************************************/
23:
24: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
25: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
26: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
27: lv_balance fnd_common_lookups.meaning%TYPE := null;
28: lv_description fnd_common_lookups.description%TYPE := null;
29: ln_application_id fnd_common_lookups.application_id%TYPE := 0;
30: lv_live_dbi ff_database_items.user_name%TYPE := null;

Line 27: lv_balance fnd_common_lookups.meaning%TYPE := null;

23:
24: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
25: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
26: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
27: lv_balance fnd_common_lookups.meaning%TYPE := null;
28: lv_description fnd_common_lookups.description%TYPE := null;
29: ln_application_id fnd_common_lookups.application_id%TYPE := 0;
30: lv_live_dbi ff_database_items.user_name%TYPE := null;
31: lv_archive_dbi ff_database_items.user_name%TYPE := null;

Line 28: lv_description fnd_common_lookups.description%TYPE := null;

24: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
25: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
26: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
27: lv_balance fnd_common_lookups.meaning%TYPE := null;
28: lv_description fnd_common_lookups.description%TYPE := null;
29: ln_application_id fnd_common_lookups.application_id%TYPE := 0;
30: lv_live_dbi ff_database_items.user_name%TYPE := null;
31: lv_archive_dbi ff_database_items.user_name%TYPE := null;
32: lv_year varchar2(4);

Line 29: ln_application_id fnd_common_lookups.application_id%TYPE := 0;

25: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
26: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
27: lv_balance fnd_common_lookups.meaning%TYPE := null;
28: lv_description fnd_common_lookups.description%TYPE := null;
29: ln_application_id fnd_common_lookups.application_id%TYPE := 0;
30: lv_live_dbi ff_database_items.user_name%TYPE := null;
31: lv_archive_dbi ff_database_items.user_name%TYPE := null;
32: lv_year varchar2(4);
33: lv_short_year varchar2(2) := null;

Line 61: from fnd_common_lookups

57: CURSOR c_get_lookup_code(cp_lookup_type in varchar2,
58: cp_lookup_code in varchar2,
59: cp_application_id in number) is
60: select 'x'
61: from fnd_common_lookups
62: where lookup_type = cp_lookup_type
63: and lookup_code = cp_lookup_code
64: and application_id = cp_application_id ;
65: