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 6837: l_lbr_mmbr_name hr_lookups.meaning%type;

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