APPS.PAY_US_W2_BOX_BAL dependencies on FND_COMMON_LOOKUPS

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

35: /************************************************************
36: ** Local Package Variables
37: ************************************************************/
38:
39: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
40: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
41: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
42: lv_balance fnd_common_lookups.meaning%TYPE := null;
43: lv_description fnd_common_lookups.description%TYPE := null;

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

36: ** Local Package Variables
37: ************************************************************/
38:
39: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
40: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
41: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
42: lv_balance fnd_common_lookups.meaning%TYPE := null;
43: lv_description fnd_common_lookups.description%TYPE := null;
44: ln_application_id fnd_common_lookups.application_id%TYPE := 0;

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

37: ************************************************************/
38:
39: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
40: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
41: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
42: lv_balance fnd_common_lookups.meaning%TYPE := null;
43: lv_description fnd_common_lookups.description%TYPE := null;
44: ln_application_id fnd_common_lookups.application_id%TYPE := 0;
45: lv_live_dbi ff_database_items.user_name%TYPE := null;

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

38:
39: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
40: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
41: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
42: lv_balance fnd_common_lookups.meaning%TYPE := null;
43: lv_description fnd_common_lookups.description%TYPE := null;
44: ln_application_id fnd_common_lookups.application_id%TYPE := 0;
45: lv_live_dbi ff_database_items.user_name%TYPE := null;
46: lv_archive_dbi ff_database_items.user_name%TYPE := null;

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

39: lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
40: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
41: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
42: lv_balance fnd_common_lookups.meaning%TYPE := null;
43: lv_description fnd_common_lookups.description%TYPE := null;
44: ln_application_id fnd_common_lookups.application_id%TYPE := 0;
45: lv_live_dbi ff_database_items.user_name%TYPE := null;
46: lv_archive_dbi ff_database_items.user_name%TYPE := null;
47: lv_business_group_name hr_organization_units.name%TYPE;

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

40: lv_lookup_type fnd_common_lookups.lookup_type%TYPE := null;
41: lv_enabled_flag fnd_common_lookups.enabled_flag%TYPE := null;
42: lv_balance fnd_common_lookups.meaning%TYPE := null;
43: lv_description fnd_common_lookups.description%TYPE := null;
44: ln_application_id fnd_common_lookups.application_id%TYPE := 0;
45: lv_live_dbi ff_database_items.user_name%TYPE := null;
46: lv_archive_dbi ff_database_items.user_name%TYPE := null;
47: lv_business_group_name hr_organization_units.name%TYPE;
48:

Line 75: from fnd_common_lookups

71: CURSOR c_get_lookup_code(cp_lookup_type in varchar2,
72: cp_lookup_code in varchar2,
73: cp_application_id in number) is
74: select 'x'
75: from fnd_common_lookups
76: where lookup_type = cp_lookup_type
77: and lookup_code = cp_lookup_code
78: and application_id = cp_application_id
79: union

Line 81: from fnd_common_lookups

77: and lookup_code = cp_lookup_code
78: and application_id = cp_application_id
79: union
80: select 'x'
81: from fnd_common_lookups
82: where lookup_type = 'W2 BOX 14'
83: and lookup_code = cp_lookup_code
84: and application_id = cp_application_id ;
85: