APPS.PQH_GSP_STAGE_TO_HR dependencies on HR_LOOKUPS

Line 32: from hr_lookups

28: l_proc varchar2(72) := g_package||'get_le_pt_name';
29: l_name varchar2(80) ;
30: begin
31: select meaning into l_name
32: from hr_lookups
33: where lookup_type = 'PQH_GSP_LE_PT_NAME'
34: and lookup_code = decode(p_cd,'PROG','PROG_LE'
35: ,'SYNC','SYNC_LE'
36: ,'PLAN','GSP_PT');

Line 754: from hr_lookups lkp, pay_rates rt

750: elsif p_frequency is not null then
751: begin
752: select rt.rate_id
753: into l_rate_id
754: from hr_lookups lkp, pay_rates rt
755: where lkp.lookup_code = p_frequency
756: and rt.rate_type ='G'
757: and rt.business_group_id = p_business_group_id
758: and lkp.lookup_type = 'PQH_GSP_GEN_PAY_RATE_NAME'