APPS.PAY_LIVEARCHIVE_PKG dependencies on FND_COMMON_LOOKUPS

Line 890: FROM fnd_common_lookups

886: CURSOR c_box_description( c_lookup_type varchar2,
887: c_meaning varchar2
888: )
889: IS SELECT description,to_char(sysdate,'mm/dd/yyyy HH:MI')
890: FROM fnd_common_lookups
891: WHERE application_id = 801
892: AND lookup_type = c_lookup_type
893: AND meaning = c_meaning;
894:

Line 948: lvc_lookup_type fnd_common_lookups.lookup_type%type;

944: lvc_year varchar2(4);
945: lvn_level number := 0;
946: lvn_archive_value number := 0;
947: lvn_live_value number := 0;
948: lvc_lookup_type fnd_common_lookups.lookup_type%type;
949: lvc_lookup_meaning fnd_common_lookups.meaning%type;
950: lvc_lookup_description fnd_common_lookups.description%type;
951: lvn_diff_value number := 0;
952: lvc_balance_name varchar2(240);

Line 949: lvc_lookup_meaning fnd_common_lookups.meaning%type;

945: lvn_level number := 0;
946: lvn_archive_value number := 0;
947: lvn_live_value number := 0;
948: lvc_lookup_type fnd_common_lookups.lookup_type%type;
949: lvc_lookup_meaning fnd_common_lookups.meaning%type;
950: lvc_lookup_description fnd_common_lookups.description%type;
951: lvn_diff_value number := 0;
952: lvc_balance_name varchar2(240);
953: lvn_employee_count number := 0;

Line 950: lvc_lookup_description fnd_common_lookups.description%type;

946: lvn_archive_value number := 0;
947: lvn_live_value number := 0;
948: lvc_lookup_type fnd_common_lookups.lookup_type%type;
949: lvc_lookup_meaning fnd_common_lookups.meaning%type;
950: lvc_lookup_description fnd_common_lookups.description%type;
951: lvn_diff_value number := 0;
952: lvc_balance_name varchar2(240);
953: lvn_employee_count number := 0;
954: lvn_diff_count number := 0;