eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_BENEFITS_EIT dependencies on PER_ALL_PEOPLE_F

Line 6: p_person_id per_all_people_f.person_id%type,

2: /* $Header: ghbenenr.pkb 120.7 2012/01/19 06:28:20 rpahune ship $ */
3: PROCEDURE ghr_benefits_fehb
4: (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_person_id per_all_people_f.person_id%type,
7: p_effective_date VARCHAR2,
8: p_business_group_id per_all_people_f.business_group_id%type,
9: p_pl_code ben_pl_f.short_code%type,
10: p_opt_code ben_opt_f.short_code%type,

Line 8: p_business_group_id per_all_people_f.business_group_id%type,

4: (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_person_id per_all_people_f.person_id%type,
7: p_effective_date VARCHAR2,
8: p_business_group_id per_all_people_f.business_group_id%type,
9: p_pl_code ben_pl_f.short_code%type,
10: p_opt_code ben_opt_f.short_code%type,
11: p_pre_tax varchar2,
12: p_assignment_id per_all_assignments_f.assignment_id%type,

Line 101: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) IS

97:
98: CURSOR get_elig_chc_id_opt(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
99: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
100: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
101: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) IS
102: SELECT elig_per_elctbl_chc_id,
103: pil.per_in_ler_id,
104: prtt_enrt_rslt_id
105: FROM ben_elig_per_ELCTBL_chc chc ,

Line 121: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) is

117:
118: Cursor get_elig_chc_id(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
119: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
120: c_ptip_id ben_ptip_f.ptip_id%type,
121: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) is
122: select elig_per_elctbl_chc_id,
123: pil.per_in_ler_id,
124: prtt_enrt_rslt_id
125: from ben_elig_per_ELCTBL_chc chc ,

Line 141: l_person_id per_all_people_f.person_id%type ;

137: Nothing_to_do EXCEPTION;
138: ben_enrt_exists EXCEPTION;
139:
140: l_exists BOOLEAN;
141: l_person_id per_all_people_f.person_id%type ;
142: l_effective_date date;
143: l_warning boolean;
144: l_business_group_id per_all_people_f.business_group_id%type;
145: l_pl_code ben_pl_f.short_code%type ;

Line 144: l_business_group_id per_all_people_f.business_group_id%type;

140: l_exists BOOLEAN;
141: l_person_id per_all_people_f.person_id%type ;
142: l_effective_date date;
143: l_warning boolean;
144: l_business_group_id per_all_people_f.business_group_id%type;
145: l_pl_code ben_pl_f.short_code%type ;
146: l_opt_code ben_opt_f.short_code%type;
147: l_pgm_id ben_pgm_f.pgm_id%type;
148: l_err_msg varchar2(2000);

Line 606: p_person_id per_all_people_f.person_id%type,

602:
603: PROCEDURE ghr_benefits_tsp
604: (errbuf OUT NOCOPY VARCHAR2,
605: retcode OUT NOCOPY NUMBER,
606: p_person_id per_all_people_f.person_id%type,
607: p_effective_date VARCHAR2,
608: p_business_group_id per_all_people_f.business_group_id%type,
609: p_tsp_status varchar2,
610: p_opt_name ben_opt_f.name%type,

Line 608: p_business_group_id per_all_people_f.business_group_id%type,

604: (errbuf OUT NOCOPY VARCHAR2,
605: retcode OUT NOCOPY NUMBER,
606: p_person_id per_all_people_f.person_id%type,
607: p_effective_date VARCHAR2,
608: p_business_group_id per_all_people_f.business_group_id%type,
609: p_tsp_status varchar2,
610: p_opt_name ben_opt_f.name%type,
611: p_opt_val number
612: )

Line 690: c_person_id per_all_people_f.person_id%type) IS

686:
687: CURSOR get_elig_chc_id_opt(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
688: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
689: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
690: c_person_id per_all_people_f.person_id%type) IS
691: SELECT elig_per_elctbl_chc_id,
692: pil.per_in_ler_id
693: FROM ben_elig_per_ELCTBL_chc chc ,
694: ben_per_in_ler pil

Line 714: l_person_id per_all_people_f.person_id%type ;

710: Nothing_to_do EXCEPTION;
711: ben_enrt_exists EXCEPTION;
712:
713: l_exists BOOLEAN;
714: l_person_id per_all_people_f.person_id%type ;
715: l_effective_date date;
716: l_business_group_id per_all_people_f.business_group_id%type;
717: l_pl_code ben_pl_f.short_code%type ;
718: l_opt_name ben_opt_f.name%type;

Line 716: l_business_group_id per_all_people_f.business_group_id%type;

712:
713: l_exists BOOLEAN;
714: l_person_id per_all_people_f.person_id%type ;
715: l_effective_date date;
716: l_business_group_id per_all_people_f.business_group_id%type;
717: l_pl_code ben_pl_f.short_code%type ;
718: l_opt_name ben_opt_f.name%type;
719: l_pgm_id ben_pgm_f.pgm_id%type;
720: l_err_msg varchar2(2000);

Line 891: c_person_id per_all_people_f.person_id%type) */

887:
888: /*(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
889: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
890: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
891: c_person_id per_all_people_f.person_id%type) */
892: hr_utility.set_location('p_manage_life_events done' ,1234);
893: for get_elig_chc_id in get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
894: l_ptip_id , l_oipl_id , l_person_id) loop
895: l_elig_per_elctbl_chc_id := get_elig_chc_id.elig_per_elctbl_chc_id;

Line 967: p_person_id per_all_people_f.person_id%type,

963: --Bug # 4122470 FEGLI
964: PROCEDURE ghr_benefits_fegli
965: (errbuf OUT NOCOPY VARCHAR2,
966: retcode OUT NOCOPY NUMBER,
967: p_person_id per_all_people_f.person_id%type,
968: p_effective_date VARCHAR2,
969: p_business_group_id per_all_people_f.business_group_id%type,
970: p_pl_code ben_pl_f.short_code%type,
971: p_opt_code ben_opt_f.short_code%type,

Line 969: p_business_group_id per_all_people_f.business_group_id%type,

965: (errbuf OUT NOCOPY VARCHAR2,
966: retcode OUT NOCOPY NUMBER,
967: p_person_id per_all_people_f.person_id%type,
968: p_effective_date VARCHAR2,
969: p_business_group_id per_all_people_f.business_group_id%type,
970: p_pl_code ben_pl_f.short_code%type,
971: p_opt_code ben_opt_f.short_code%type,
972: p_assignment_id per_all_assignments_f.assignment_id%type) IS
973:

Line 1064: c_person_id per_all_people_f.person_id%type) is

1060: c_plip_id ben_plip_f.plip_id%type,
1061: c_ptip_id ben_ptip_f.ptip_id%type,
1062: c_oipl_id ben_oipl_f.oipl_id%type,
1063: c_ler_id ben_ler_f.ler_id%type,
1064: c_person_id per_all_people_f.person_id%type) is
1065: SELECT elig_per_elctbl_chc_id,
1066: pil.per_in_ler_id
1067: FROM ben_elig_per_ELCTBL_chc chc ,
1068: ben_per_in_ler pil

Line 1085: c_person_id per_all_people_f.person_id%type) is

1081: c_pl_id ben_pl_f.pl_id%type,
1082: c_plip_id ben_plip_f.plip_id%type,
1083: c_ptip_id ben_ptip_f.ptip_id%type,
1084: c_ler_id ben_ler_f.ler_id%type,
1085: c_person_id per_all_people_f.person_id%type) is
1086: SELECT elig_per_elctbl_chc_id,
1087: pil.per_in_ler_id
1088: FROM ben_elig_per_ELCTBL_chc chc ,
1089: ben_per_in_ler pil

Line 1131: l_person_id per_all_people_f.person_id%type ;

1127: Nothing_to_do EXCEPTION;
1128: ben_enrt_exists EXCEPTION;
1129:
1130: l_exists BOOLEAN;
1131: l_person_id per_all_people_f.person_id%type ;
1132: l_effective_date date;
1133: l_warning boolean;
1134: l_business_group_id per_all_people_f.business_group_id%type;
1135: l_pl_code ben_pl_f.short_code%type ;

Line 1134: l_business_group_id per_all_people_f.business_group_id%type;

1130: l_exists BOOLEAN;
1131: l_person_id per_all_people_f.person_id%type ;
1132: l_effective_date date;
1133: l_warning boolean;
1134: l_business_group_id per_all_people_f.business_group_id%type;
1135: l_pl_code ben_pl_f.short_code%type ;
1136: l_opt_code ben_opt_f.short_code%type;
1137: l_pgm_id ben_pgm_f.pgm_id%type;
1138: l_err_msg varchar2(2000);