APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on HR_LOOKUPS

Line 867: from hr_lookups hl

863: ---------------------------------------------------------------
864: -- Added to Fetch Lookup Meaning for Program Type
865: cursor c_lookup_meaning(c_lookup_code in varchar2,c_lookup_type in varchar2) is
866: select hl.meaning
867: from hr_lookups hl
868: where hl.lookup_code = c_lookup_code
869: and hl.lookup_type = c_lookup_type;
870:
871: l_program_type_meaning hr_lookups.meaning%type;

Line 871: l_program_type_meaning hr_lookups.meaning%type;

867: from hr_lookups hl
868: where hl.lookup_code = c_lookup_code
869: and hl.lookup_type = c_lookup_type;
870:
871: l_program_type_meaning hr_lookups.meaning%type;
872:
873: cursor c_object_exists(c_pk_id number,
874: c_table_alias varchar2) is
875: select null

Line 6836: l_lbr_mmbr_name hr_lookups.meaning%type;

6832: (
6833: p_lbr_mmbr_flag in varchar2
6834: ) return varchar2 is
6835:
6836: l_lbr_mmbr_name hr_lookups.meaning%type;
6837:
6838: begin
6839:
6840: l_lbr_mmbr_name := hr_general.decode_lookup('YES_NO',p_lbr_mmbr_flag);