[Home] [Help]
884: --
885: --
886: cursor c1 is
887: select null
888: from per_all_people a, per_contact_relationships c
889: where a.person_id = p_ttee_person_id
890: and a.person_id = c.contact_person_id
891: and c.person_id = p_bnf_person_id
892: and p_validation_start_date <= nvl(c.date_end, p_validation_start_date)
1066: --- # 3212439 parametrer added to find the relationship
1067: cursor c_bnf_person_rel_typ (c_contact_type varchar2) is
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
1359: --
1360: --
1361: cursor c_opt_dsgn_rqmt is
1362: select null
1363: from per_contact_relationships pcr
1364: , ben_per_in_ler pil
1365: where pil.per_in_ler_id = p_per_in_ler_id
1366: and pil.business_group_id = p_business_group_id
1367: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1394: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id ) ;
1395: --
1396: cursor c_oipl_dsgn_rqmt is
1397: select null
1398: from per_contact_relationships pcr
1399: , ben_per_in_ler pil
1400: where pil.per_in_ler_id = p_per_in_ler_id
1401: and pil.business_group_id = p_business_group_id
1402: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1425: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id ) ;
1426: --
1427: cursor c_pl_dsgn_rqmt is
1428: select null
1429: from per_contact_relationships pcr
1430: , ben_per_in_ler pil
1431: where pil.per_in_ler_id = p_per_in_ler_id
1432: and pil.business_group_id = p_business_group_id
1433: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1465: and pil.person_id = p_bnf_person_id ;
1466: --
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