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 793: from hr_lookups lkp, pay_rates rt

789: elsif p_frequency is not null then
790: begin
791: select rt.rate_id
792: into l_rate_id
793: from hr_lookups lkp, pay_rates rt
794: where lkp.lookup_code = p_frequency
795: and rt.rate_type ='G'
796: and rt.business_group_id = p_business_group_id
797: and lkp.lookup_type = 'PQH_GSP_GEN_PAY_RATE_NAME'