APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_ELIG_PER_F

Line 1444: (elig_per_id ben_elig_per_f.elig_per_id%type

1440: --
1441: TYPE cur_type IS REF CURSOR;
1442: --
1443: type g_efc_row is record
1444: (elig_per_id ben_elig_per_f.elig_per_id%type
1445: ,effective_start_date ben_elig_per_f.effective_start_date%type
1446: ,effective_end_date ben_elig_per_f.effective_end_date%type
1447: ,comp_ref_amt ben_elig_per_f.comp_ref_amt%type
1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type

Line 1445: ,effective_start_date ben_elig_per_f.effective_start_date%type

1441: TYPE cur_type IS REF CURSOR;
1442: --
1443: type g_efc_row is record
1444: (elig_per_id ben_elig_per_f.elig_per_id%type
1445: ,effective_start_date ben_elig_per_f.effective_start_date%type
1446: ,effective_end_date ben_elig_per_f.effective_end_date%type
1447: ,comp_ref_amt ben_elig_per_f.comp_ref_amt%type
1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type
1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type

Line 1446: ,effective_end_date ben_elig_per_f.effective_end_date%type

1442: --
1443: type g_efc_row is record
1444: (elig_per_id ben_elig_per_f.elig_per_id%type
1445: ,effective_start_date ben_elig_per_f.effective_start_date%type
1446: ,effective_end_date ben_elig_per_f.effective_end_date%type
1447: ,comp_ref_amt ben_elig_per_f.comp_ref_amt%type
1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type
1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type
1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type

Line 1447: ,comp_ref_amt ben_elig_per_f.comp_ref_amt%type

1443: type g_efc_row is record
1444: (elig_per_id ben_elig_per_f.elig_per_id%type
1445: ,effective_start_date ben_elig_per_f.effective_start_date%type
1446: ,effective_end_date ben_elig_per_f.effective_end_date%type
1447: ,comp_ref_amt ben_elig_per_f.comp_ref_amt%type
1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type
1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type
1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type
1451: ,person_id ben_elig_per_f.person_id%type

Line 1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type

1444: (elig_per_id ben_elig_per_f.elig_per_id%type
1445: ,effective_start_date ben_elig_per_f.effective_start_date%type
1446: ,effective_end_date ben_elig_per_f.effective_end_date%type
1447: ,comp_ref_amt ben_elig_per_f.comp_ref_amt%type
1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type
1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type
1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type
1451: ,person_id ben_elig_per_f.person_id%type
1452: ,pgm_id ben_elig_per_f.pgm_id%type

Line 1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type

1445: ,effective_start_date ben_elig_per_f.effective_start_date%type
1446: ,effective_end_date ben_elig_per_f.effective_end_date%type
1447: ,comp_ref_amt ben_elig_per_f.comp_ref_amt%type
1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type
1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type
1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type
1451: ,person_id ben_elig_per_f.person_id%type
1452: ,pgm_id ben_elig_per_f.pgm_id%type
1453: ,ptip_id ben_elig_per_f.ptip_id%type

Line 1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type

1446: ,effective_end_date ben_elig_per_f.effective_end_date%type
1447: ,comp_ref_amt ben_elig_per_f.comp_ref_amt%type
1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type
1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type
1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type
1451: ,person_id ben_elig_per_f.person_id%type
1452: ,pgm_id ben_elig_per_f.pgm_id%type
1453: ,ptip_id ben_elig_per_f.ptip_id%type
1454: ,plip_id ben_elig_per_f.plip_id%type

Line 1451: ,person_id ben_elig_per_f.person_id%type

1447: ,comp_ref_amt ben_elig_per_f.comp_ref_amt%type
1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type
1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type
1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type
1451: ,person_id ben_elig_per_f.person_id%type
1452: ,pgm_id ben_elig_per_f.pgm_id%type
1453: ,ptip_id ben_elig_per_f.ptip_id%type
1454: ,plip_id ben_elig_per_f.plip_id%type
1455: ,pl_id ben_elig_per_f.pl_id%type

Line 1452: ,pgm_id ben_elig_per_f.pgm_id%type

1448: ,rt_comp_ref_amt ben_elig_per_f.rt_comp_ref_amt%type
1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type
1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type
1451: ,person_id ben_elig_per_f.person_id%type
1452: ,pgm_id ben_elig_per_f.pgm_id%type
1453: ,ptip_id ben_elig_per_f.ptip_id%type
1454: ,plip_id ben_elig_per_f.plip_id%type
1455: ,pl_id ben_elig_per_f.pl_id%type
1456: ,business_group_id ben_elig_per_f.business_group_id%type

Line 1453: ,ptip_id ben_elig_per_f.ptip_id%type

1449: ,comp_ref_uom ben_elig_per_f.comp_ref_uom%type
1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type
1451: ,person_id ben_elig_per_f.person_id%type
1452: ,pgm_id ben_elig_per_f.pgm_id%type
1453: ,ptip_id ben_elig_per_f.ptip_id%type
1454: ,plip_id ben_elig_per_f.plip_id%type
1455: ,pl_id ben_elig_per_f.pl_id%type
1456: ,business_group_id ben_elig_per_f.business_group_id%type
1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

Line 1454: ,plip_id ben_elig_per_f.plip_id%type

1450: ,rt_comp_ref_uom ben_elig_per_f.rt_comp_ref_uom%type
1451: ,person_id ben_elig_per_f.person_id%type
1452: ,pgm_id ben_elig_per_f.pgm_id%type
1453: ,ptip_id ben_elig_per_f.ptip_id%type
1454: ,plip_id ben_elig_per_f.plip_id%type
1455: ,pl_id ben_elig_per_f.pl_id%type
1456: ,business_group_id ben_elig_per_f.business_group_id%type
1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1458: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type

Line 1455: ,pl_id ben_elig_per_f.pl_id%type

1451: ,person_id ben_elig_per_f.person_id%type
1452: ,pgm_id ben_elig_per_f.pgm_id%type
1453: ,ptip_id ben_elig_per_f.ptip_id%type
1454: ,plip_id ben_elig_per_f.plip_id%type
1455: ,pl_id ben_elig_per_f.pl_id%type
1456: ,business_group_id ben_elig_per_f.business_group_id%type
1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1458: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1459: ,creation_date ben_elig_per_f.creation_date%type

Line 1456: ,business_group_id ben_elig_per_f.business_group_id%type

1452: ,pgm_id ben_elig_per_f.pgm_id%type
1453: ,ptip_id ben_elig_per_f.ptip_id%type
1454: ,plip_id ben_elig_per_f.plip_id%type
1455: ,pl_id ben_elig_per_f.pl_id%type
1456: ,business_group_id ben_elig_per_f.business_group_id%type
1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1458: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1459: ,creation_date ben_elig_per_f.creation_date%type
1460: ,last_update_date ben_elig_per_f.last_update_date%type

Line 1459: ,creation_date ben_elig_per_f.creation_date%type

1455: ,pl_id ben_elig_per_f.pl_id%type
1456: ,business_group_id ben_elig_per_f.business_group_id%type
1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1458: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1459: ,creation_date ben_elig_per_f.creation_date%type
1460: ,last_update_date ben_elig_per_f.last_update_date%type
1461: ,object_version_number ben_elig_per_f.object_version_number%type
1462: );
1463: --

Line 1460: ,last_update_date ben_elig_per_f.last_update_date%type

1456: ,business_group_id ben_elig_per_f.business_group_id%type
1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1458: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1459: ,creation_date ben_elig_per_f.creation_date%type
1460: ,last_update_date ben_elig_per_f.last_update_date%type
1461: ,object_version_number ben_elig_per_f.object_version_number%type
1462: );
1463: --
1464: c_efc_rows cur_type;

Line 1461: ,object_version_number ben_elig_per_f.object_version_number%type

1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1458: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1459: ,creation_date ben_elig_per_f.creation_date%type
1460: ,last_update_date ben_elig_per_f.last_update_date%type
1461: ,object_version_number ben_elig_per_f.object_version_number%type
1462: );
1463: --
1464: c_efc_rows cur_type;
1465: --

Line 1554: l_from_str := ' FROM ben_elig_per_f pep, '

1550: l_efc_batch := TRUE;
1551: --
1552: end if;
1553: --
1554: l_from_str := ' FROM ben_elig_per_f pep, '
1555: ||' ben_per_in_ler pil, '
1556: ||' per_all_people_f per ';
1557: --
1558: l_where_str := ' where pep.per_in_ler_id = pil.per_in_ler_id '

Line 1577: l_from_str := l_from_str||', ben_elig_per_f_efc efc ';

1573: -- Build in batch specific restrictions
1574: --
1575: if l_efc_batch then
1576: --
1577: l_from_str := l_from_str||', ben_elig_per_f_efc efc ';
1578: l_where_str := l_where_str||' and efc.elig_per_id = pep.elig_per_id '
1579: ||' and efc.effective_start_date = pep.effective_start_date '
1580: ||' and efc.effective_end_date = pep.effective_end_date '
1581: ||' and efc.efc_action_id = :action_id '

Line 1923: update ben_elig_per_f pep

1919: if l_efc_batch
1920: and l_faterr_code is null
1921: then
1922: --
1923: update ben_elig_per_f pep
1924: set pep.comp_ref_amt = l_comp_rec.comp_ref_amt,
1925: pep.rt_comp_ref_amt = l_comp_rec.rt_comp_ref_amt
1926: where pep.elig_per_id = l_efc_row.elig_per_id
1927: and pep.effective_start_date = l_efc_row.effective_start_date

Line 2003: (p_table_name => 'ben_elig_per_f'

1999: end loop;
2000: CLOSE c_efc_rows;
2001: --
2002: ben_efc_functions.conv_check
2003: (p_table_name => 'ben_elig_per_f'
2004: ,p_efctable_name => 'ben_elig_per_f_efc'
2005: --
2006: ,p_tabwhere_clause => ' (comp_ref_amt is not null '
2007: ||' or rt_comp_ref_amt is not null) '

Line 2004: ,p_efctable_name => 'ben_elig_per_f_efc'

2000: CLOSE c_efc_rows;
2001: --
2002: ben_efc_functions.conv_check
2003: (p_table_name => 'ben_elig_per_f'
2004: ,p_efctable_name => 'ben_elig_per_f_efc'
2005: --
2006: ,p_tabwhere_clause => ' (comp_ref_amt is not null '
2007: ||' or rt_comp_ref_amt is not null) '
2008: ,p_bgp_id => p_business_group_id

Line 2067: ,person_id ben_elig_per_f.person_id%type

2063: ,effective_start_date ben_elig_per_opt_f.effective_start_date%type
2064: ,effective_end_date ben_elig_per_opt_f.effective_end_date%type
2065: ,comp_ref_amt ben_elig_per_opt_f.comp_ref_amt%type
2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type
2067: ,person_id ben_elig_per_f.person_id%type
2068: ,pgm_id ben_elig_per_f.pgm_id%type
2069: ,pl_id ben_elig_per_f.pl_id%type
2070: ,opt_id ben_elig_per_opt_f.opt_id%type
2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type

Line 2068: ,pgm_id ben_elig_per_f.pgm_id%type

2064: ,effective_end_date ben_elig_per_opt_f.effective_end_date%type
2065: ,comp_ref_amt ben_elig_per_opt_f.comp_ref_amt%type
2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type
2067: ,person_id ben_elig_per_f.person_id%type
2068: ,pgm_id ben_elig_per_f.pgm_id%type
2069: ,pl_id ben_elig_per_f.pl_id%type
2070: ,opt_id ben_elig_per_opt_f.opt_id%type
2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type
2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

Line 2069: ,pl_id ben_elig_per_f.pl_id%type

2065: ,comp_ref_amt ben_elig_per_opt_f.comp_ref_amt%type
2066: ,rt_comp_ref_amt ben_elig_per_opt_f.rt_comp_ref_amt%type
2067: ,person_id ben_elig_per_f.person_id%type
2068: ,pgm_id ben_elig_per_f.pgm_id%type
2069: ,pl_id ben_elig_per_f.pl_id%type
2070: ,opt_id ben_elig_per_opt_f.opt_id%type
2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type
2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2073: ,creation_date ben_elig_per_opt_f.creation_date%type

Line 2243: ||' ben_elig_per_f pep, '

2239: --
2240: end if;
2241: --
2242: l_from_str := ' FROM ben_elig_per_opt_f epo, '
2243: ||' ben_elig_per_f pep, '
2244: ||' ben_per_in_ler pil, '
2245: ||' per_all_people_f per ';
2246: --
2247: l_where_str := ' where epo.elig_per_id = pep.elig_per_id '