DBA Data[Home] [Help]

APPS.BEN_PBN_BUS dependencies on HR_LEG_LOOKUPS

Line 1072: , hr_leg_lookups hll

1068: select pcr.contact_type,
1069: hll.meaning
1070: from per_contact_relationships pcr
1071: , ben_per_in_ler pil
1072: , hr_leg_lookups hll
1073: where pil.per_in_ler_id = p_per_in_ler_id
1074: and pil.business_group_id = p_business_group_id
1075: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1076: or pil.per_in_ler_stat_cd is null )

Line 1471: , hr_leg_lookups hll

1467: cursor c_bnf_person_rel_typ is
1468: select hll.meaning
1469: from per_contact_relationships pcr
1470: , ben_per_in_ler pil
1471: , hr_leg_lookups hll
1472: where pil.per_in_ler_id = p_per_in_ler_id
1473: and pil.business_group_id = p_business_group_id
1474: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1475: or pil.per_in_ler_stat_cd is null )