APPS.BEN_EXT_UTIL dependencies on BEN_EXTRACT

Line 1098: if ben_extract.g_pasor_dt_cd is not null then

1094: --
1095: hr_utility.set_location('Entering'||l_proc, 5);
1096:
1097: --
1098: if ben_extract.g_pasor_dt_cd is not null then
1099: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1100: end if ;
1101:
1102: hr_utility.set_location('pasor_dt_cd '||l_person_dt_cd, 5);

Line 1099: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;

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

Line 1153: if ben_extract.g_pasor_dt_cd is not null then

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

Line 1154: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;

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

Line 1175: if ben_extract.g_bdtor_dt_cd is not null then

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

Line 1176: l_benefits_dt_cd := ben_extract.g_bdtor_dt_cd ;

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

Line 1197: if ben_extract.g_pasor_dt_cd is not null then

1193: end if; --found
1194: --
1195: elsif p_data_typ_cd = 'CW' then
1196:
1197: if ben_extract.g_pasor_dt_cd is not null then
1198: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1199:
1200: if l_person_dt_cd = 'CWBEDT' then -- effective date
1201: l_person_dt := ben_ext_person.g_CWB_LE_DT;

Line 1198: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;

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