DBA Data[Home] [Help]

APPS.BEN_EXT_CHLG dependencies on BEN_PRTT_PREM_BY_MO_F

Line 316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type

312: ,update_mode varchar2(20)
313: );
314:
315: Type g_prem_mo_rec_type is RECORD
316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type

Line 317: ,val ben_prtt_prem_by_mo_f.val%type

313: );
314:
315: Type g_prem_mo_rec_type is RECORD
316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type

Line 318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type

314:
315: Type g_prem_mo_rec_type is RECORD
316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type

Line 319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type

315: Type g_prem_mo_rec_type is RECORD
316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type

Line 320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type

316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type

Line 321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type

317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type
325: ,update_mode varchar2(20)

Line 322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type

318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type
325: ,update_mode varchar2(20)
326: );

Line 323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type

319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type
325: ,update_mode varchar2(20)
326: );
327: --

Line 324: ,uom ben_prtt_prem_by_mo_f.uom%type

320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type
325: ,update_mode varchar2(20)
326: );
327: --
328: -- added for bug 6517369 to audit changes to per_disabilities_f