APPS.HR_AUTH_BRIDGE dependencies on HR_GENERAL

Line 16: HR_GENERAL.DECODE_LOOKUP('BEN_ENRT_INFO_RT_FREQ',

12: RETURN varchar2 IS
13: --
14: CURSOR c_ee_contrib IS
15: SELECT prv.cmcd_rt_val ||' '||
16: HR_GENERAL.DECODE_LOOKUP('BEN_ENRT_INFO_RT_FREQ',
17: prv.cmcd_ref_perd_cd)
18: FROM ben_prtt_rt_val prv
19: WHERE prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
20: AND prv.per_in_ler_id = p_per_in_ler_id

Line 27: HR_GENERAL.DECODE_LOOKUP('BEN_ENRT_INFO_RT_FREQ',

23: AND prv.dsply_on_enrt_flag = 'Y';
24:
25: CURSOR c_er_contrib IS
26: SELECT prv.cmcd_rt_val ||' '||
27: HR_GENERAL.DECODE_LOOKUP('BEN_ENRT_INFO_RT_FREQ',
28: prv.cmcd_ref_perd_cd)
29: FROM ben_prtt_rt_val prv
30: WHERE prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
31: AND prv.per_in_ler_id = p_per_in_ler_id

Line 146: HR_GENERAL.DECODE_LOOKUP('BEN_PRMRY_CARE_PRVDR_TYP',pcp.prmry_care_prvdr_typ_cd) primary_care_provider

142: --
143:
144: CURSOR c_pcp IS
145: SELECT pcp.name ||' '||
146: HR_GENERAL.DECODE_LOOKUP('BEN_PRMRY_CARE_PRVDR_TYP',pcp.prmry_care_prvdr_typ_cd) primary_care_provider
147: FROM ben_prmry_care_prvdr_f pcp
148: WHERE pcp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
149: AND pcp.business_group_id = p_business_group_id
150: AND p_effective_date BETWEEN pcp.effective_start_date AND pcp.effective_end_date;

Line 253: SELECT HR_GENERAL.DECODE_LOOKUP('CONTACT',pcr.contact_type) contact_type

249: RETURN varchar2 IS
250: --
251:
252: CURSOR c_contacts IS
253: SELECT HR_GENERAL.DECODE_LOOKUP('CONTACT',pcr.contact_type) contact_type
254: FROM per_contact_relationships pcr
255: WHERE pcr.person_id = p_person_id
256: AND pcr.contact_person_id = p_contact_person_id
257: AND p_effective_date BETWEEN NVL(pcr.date_start,p_effective_date) AND NVL(pcr.date_end,p_effective_date)