[Home] [Help]
511: l_person_id number(15);
512: l_pl_id number(15);
513: l_oipl_id number(15);
514: l_opt_id number(15);
515: l_contact_type per_contact_relationships.contact_type%type ; -- UTF8 varchar2(30);
516: l_t_mx_dpnts_alwd_num number(15);
517: l_t_no_mx_num_dfnd_flag varchar2(1);
518: l_r_mx_dpnts_alwd_num number(15);
519: l_r_no_mx_num_dfnd_flag varchar2(1);
541: ;
542: --
543: cursor info2_c is
544: select c.contact_type
545: from per_contact_relationships c
546: where c.person_id = l_person_id
547: and c.contact_person_id = p_dpnt_person_id
548: -- bug 1762932 added personal_flag
549: and nvl(c.personal_flag,'N') = 'Y'
629: -- by the appropriate dsgn rqmt.
630:
631: cursor rlshp_num_dpnt_c is
632: select count(*)
633: from per_contact_relationships c
634: , ben_elig_cvrd_dpnt_f d
635: where
636: c.person_id = l_person_id
637: and c.contact_person_id = d.dpnt_person_id
917: cvr.person_id, bpl.NAME, crt.CRT_ORDR_TYP_CD
918: FROM ben_crt_ordr crt,
919: ben_crt_ordr_cvrd_per cvr,
920: per_all_people_f per,
921: per_contact_relationships con,
922: hr_lookups lkp,
923: ben_pl_f bpl
924: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
925: AND crt.person_id = rslt_person_id
964: cvr.person_id, bpt.NAME, crt.CRT_ORDR_TYP_CD
965: FROM ben_crt_ordr crt,
966: ben_crt_ordr_cvrd_per cvr,
967: per_all_people_f per,
968: per_contact_relationships con,
969: hr_lookups lkp,
970: ben_pl_typ_f bpt
971: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
972: AND crt.person_id = rslt_person_id
1008: );
1009:
1010: --
1011: l_name VARCHAR2 (500);
1012: l_contact_type per_contact_relationships.contact_type%TYPE;
1013: l_dpnt_id NUMBER (15);
1014: l_crt_ordr_typ_cd VARCHAR2(30);
1015: l_crt_ordr_meaning VARCHAR2(80);
1016: --