APPS.PAY_LIVEARCHIVE_PKG dependencies on FND_COMMON_LOOKUPS

Line 801: FROM fnd_common_lookups

797: CURSOR c_box_description( c_lookup_type varchar2,
798: c_meaning varchar2
799: )
800: IS SELECT description,to_char(sysdate,'mm/dd/yyyy HH:MI')
801: FROM fnd_common_lookups
802: WHERE application_id = 801
803: AND lookup_type = c_lookup_type
804: AND meaning = c_meaning;
805:

Line 859: lvc_lookup_type fnd_common_lookups.lookup_type%type;

855: lvc_year varchar2(4);
856: lvn_level number := 0;
857: lvn_archive_value number := 0;
858: lvn_live_value number := 0;
859: lvc_lookup_type fnd_common_lookups.lookup_type%type;
860: lvc_lookup_meaning fnd_common_lookups.meaning%type;
861: lvc_lookup_description fnd_common_lookups.description%type;
862: lvn_diff_value number := 0;
863: lvc_balance_name varchar2(240);

Line 860: lvc_lookup_meaning fnd_common_lookups.meaning%type;

856: lvn_level number := 0;
857: lvn_archive_value number := 0;
858: lvn_live_value number := 0;
859: lvc_lookup_type fnd_common_lookups.lookup_type%type;
860: lvc_lookup_meaning fnd_common_lookups.meaning%type;
861: lvc_lookup_description fnd_common_lookups.description%type;
862: lvn_diff_value number := 0;
863: lvc_balance_name varchar2(240);
864: lvn_employee_count number := 0;

Line 861: lvc_lookup_description fnd_common_lookups.description%type;

857: lvn_archive_value number := 0;
858: lvn_live_value number := 0;
859: lvc_lookup_type fnd_common_lookups.lookup_type%type;
860: lvc_lookup_meaning fnd_common_lookups.meaning%type;
861: lvc_lookup_description fnd_common_lookups.description%type;
862: lvn_diff_value number := 0;
863: lvc_balance_name varchar2(240);
864: lvn_employee_count number := 0;
865: lvn_diff_count number := 0;