APPS.BEN_EXT_UTIL dependencies on BEN_EXTRACT

Line 1094: if ben_extract.g_pasor_dt_cd is not null then

1090: --
1091: hr_utility.set_location('Entering'||l_proc, 5);
1092:
1093: --
1094: if ben_extract.g_pasor_dt_cd is not null then
1095: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1096: end if ;
1097:
1098: hr_utility.set_location('pasor_dt_cd '||l_person_dt_cd, 5);

Line 1095: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;

1091: hr_utility.set_location('Entering'||l_proc, 5);
1092:
1093: --
1094: if ben_extract.g_pasor_dt_cd is not null then
1095: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1096: end if ;
1097:
1098: hr_utility.set_location('pasor_dt_cd '||l_person_dt_cd, 5);
1099: hr_utility.set_location('effective date '||p_effective_date, 5);

Line 1149: if ben_extract.g_pasor_dt_cd is not null then

1145: end if ;
1146: --- Change and communication specifc
1147: if p_data_typ_cd in ( 'C', 'CM') then
1148:
1149: if ben_extract.g_pasor_dt_cd is not null then
1150: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1151:
1152:
1153: if l_person_dt_cd = 'CLEOD' then -- life event occured

Line 1150: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;

1146: --- Change and communication specifc
1147: if p_data_typ_cd in ( 'C', 'CM') then
1148:
1149: if ben_extract.g_pasor_dt_cd is not null then
1150: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1151:
1152:
1153: if l_person_dt_cd = 'CLEOD' then -- life event occured
1154: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;

Line 1171: if ben_extract.g_bdtor_dt_cd is not null then

1167: end if;
1168: end if; --found
1169: --l_benefits_dt := null;
1170: -- Benefit override code setup
1171: if ben_extract.g_bdtor_dt_cd is not null then
1172: l_benefits_dt_cd := ben_extract.g_bdtor_dt_cd ;
1173:
1174: if l_benefits_dt_cd = 'CLEOD' then -- life event occured
1175: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;

Line 1172: l_benefits_dt_cd := ben_extract.g_bdtor_dt_cd ;

1168: end if; --found
1169: --l_benefits_dt := null;
1170: -- Benefit override code setup
1171: if ben_extract.g_bdtor_dt_cd is not null then
1172: l_benefits_dt_cd := ben_extract.g_bdtor_dt_cd ;
1173:
1174: if l_benefits_dt_cd = 'CLEOD' then -- life event occured
1175: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;
1176: elsif l_benefits_dt_cd = 'CDBLEOD' then -- day before life event occured

Line 1193: if ben_extract.g_pasor_dt_cd is not null then

1189: end if; --found
1190: --
1191: elsif p_data_typ_cd = 'CW' then
1192:
1193: if ben_extract.g_pasor_dt_cd is not null then
1194: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1195:
1196: if l_person_dt_cd = 'CWBEDT' then -- effective date
1197: l_person_dt := ben_ext_person.g_CWB_LE_DT;

Line 1194: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;

1190: --
1191: elsif p_data_typ_cd = 'CW' then
1192:
1193: if ben_extract.g_pasor_dt_cd is not null then
1194: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1195:
1196: if l_person_dt_cd = 'CWBEDT' then -- effective date
1197: l_person_dt := ben_ext_person.g_CWB_LE_DT;
1198: elsif l_person_dt_cd = 'CWBFDT' then -- life evt ocrd dt