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.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PER_IN_LER

Line 714: ,p_pil_row IN ben_per_in_ler%ROWTYPE

710: p_formula_id IN NUMBER
711: --
712: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
713: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
714: ,p_pil_row IN ben_per_in_ler%ROWTYPE
715: --
716: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
717: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
718: --

Line 955: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE

951: PROCEDURE cache_data_structures(
952: p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
953: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
954: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
955: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
956: ,p_business_group_id IN NUMBER
957: ,p_effective_date IN DATE
958: ,p_person_id IN NUMBER
959: ,p_pgm_id IN NUMBER

Line 1040: FROM ben_elig_per_opt_f epo, ben_elig_per_f pep, ben_per_in_ler pil

1036: ,NULL
1037: ,NULL
1038: ,NULL
1039: ,NULL
1040: FROM ben_elig_per_opt_f epo, ben_elig_per_f pep, ben_per_in_ler pil
1041: WHERE epo.elig_per_id = pep.elig_per_id
1042: AND pep.person_id = c_person_id
1043: AND NVL(pep.pl_id
1044: ,-1) = c_pl_id

Line 1122: FROM ben_elig_per_f pep, ben_per_in_ler pil

1118: ,NULL
1119: ,NULL
1120: ,NULL
1121: ,NULL
1122: FROM ben_elig_per_f pep, ben_per_in_ler pil
1123: WHERE pep.person_id = c_person_id
1124: AND NVL(pep.pl_id
1125: ,-1) = c_pl_id
1126: AND NVL(pep.plip_id

Line 2300: ,p_pil_row IN ben_per_in_ler%ROWTYPE

2296: FUNCTION los_calculation(
2297: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2298: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2299: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2300: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2301: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2302: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2303: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_los_rec_obj
2304: ,p_comp_rec IN OUT NOCOPY g_cache_structure

Line 2587: ,p_pil_row IN ben_per_in_ler%ROWTYPE

2583: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2584: ,p_per_row IN per_all_people_f%ROWTYPE
2585: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2586: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2587: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2588: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2589: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2590: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_age_rec_obj
2591: ,p_effective_date IN DATE

Line 2614: l_pil_rec ben_per_in_ler%ROWTYPE;

2610: l_start_date DATE;
2611: l_result NUMBER;
2612: l_dummy_num NUMBER;
2613: l_outputs ff_exec.outputs_t;
2614: l_pil_rec ben_per_in_ler%ROWTYPE;
2615: l_pl_rec ben_pl_f%ROWTYPE;
2616: l_oipl_rec ben_oipl_f%ROWTYPE;
2617: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2618: l_ass_rec per_all_assignments_f%ROWTYPE;

Line 3053: l_pil_rec ben_per_in_ler%ROWTYPE;

3049: l_package VARCHAR2(80) := g_package || '.hours_calculation';
3050: l_start_date DATE;
3051: l_result NUMBER;
3052: l_outputs ff_exec.outputs_t;
3053: l_pil_rec ben_per_in_ler%ROWTYPE;
3054: l_pl_rec ben_pl_f%ROWTYPE;
3055: l_oipl_rec ben_oipl_f%ROWTYPE;
3056: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3057: l_loc_rec hr_locations_all%ROWTYPE;

Line 3400: l_pil_rec ben_per_in_ler%ROWTYPE;

3396: l_package VARCHAR2(80) := g_package || '.comp_calculation';
3397: l_start_date DATE;
3398: l_result NUMBER;
3399: l_outputs ff_exec.outputs_t;
3400: l_pil_rec ben_per_in_ler%ROWTYPE;
3401: l_pl_rec ben_pl_f%ROWTYPE;
3402: l_oipl_rec ben_oipl_f%ROWTYPE;
3403: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3404: l_loc_rec hr_locations_all%ROWTYPE;

Line 3772: ,p_pil_row IN ben_per_in_ler%ROWTYPE

3768: (p_calculate_only_mode in boolean default false
3769: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3770: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3771: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3772: ,p_pil_row IN ben_per_in_ler%ROWTYPE
3773: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
3774: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3775: ,p_person_id IN NUMBER
3776: ,p_business_group_id IN NUMBER

Line 4500: ,p_pil_row IN ben_per_in_ler%ROWTYPE

4496: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
4497: ,p_per_row IN per_all_people_f%ROWTYPE
4498: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
4499: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
4500: ,p_pil_row IN ben_per_in_ler%ROWTYPE
4501: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
4502: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
4503: ,p_person_id IN NUMBER
4504: ,p_business_group_id IN NUMBER

Line 5456: ,p_pil_row IN ben_per_in_ler%ROWTYPE

5452: (p_calculate_only_mode in boolean default false
5453: ,p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
5454: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5455: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
5456: ,p_pil_row IN ben_per_in_ler%ROWTYPE
5457: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
5458: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
5459: ,p_person_id IN NUMBER
5460: ,p_business_group_id IN NUMBER

Line 6761: ,p_pil_row IN ben_per_in_ler%ROWTYPE

6757: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
6758: ,p_per_row IN per_all_people_f%ROWTYPE
6759: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
6760: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
6761: ,p_pil_row IN ben_per_in_ler%ROWTYPE
6762: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
6763: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
6764: ,p_person_id IN NUMBER
6765: ,p_business_group_id IN NUMBER

Line 7597: ,p_pil_row IN ben_per_in_ler%ROWTYPE

7593: (p_calculate_only_mode in boolean default false
7594: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
7595: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7596: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
7597: ,p_pil_row IN ben_per_in_ler%ROWTYPE
7598: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
7599: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
7600: ,p_person_id IN NUMBER
7601: ,p_business_group_id IN NUMBER

Line 8399: ,p_pil_row IN ben_per_in_ler%ROWTYPE

8395: (p_calculate_only_mode in boolean default false
8396: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
8397: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8398: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
8399: ,p_pil_row IN ben_per_in_ler%ROWTYPE
8400: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
8401: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
8402: ,p_person_id IN NUMBER
8403: ,p_business_group_id IN NUMBER

Line 9769: l_cbr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;

9765: AND pel.business_group_id = crp.business_group_id;
9766: --
9767: l_pen_rec c_get_prtt_enrt_rslt%ROWTYPE;
9768: l_date date;
9769: l_cbr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
9770: l_month_last_day date;
9771: l_allwd_underpymt_value number;
9772: l_allwd_underpymt_pct number;
9773:

Line 10108: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;

10104: l_exists VARCHAR2(1);
10105: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
10106: l_dys_no_enrl_not_elig_num ben_lee_rsn_f.dys_no_enrl_not_elig_num%TYPE;
10107: l_rec ben_person_object.g_person_date_info_rec;
10108: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;
10109: l_object_version_number ben_cbr_quald_bnf.object_version_number%TYPE;
10110: l_effective_date DATE;
10111: l_due_date DATE;
10112: l_eff_due_date DATE;

Line 10115: l_init_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

10111: l_due_date DATE;
10112: l_eff_due_date DATE;
10113: l_elcns_made_dt DATE;
10114: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%TYPE;
10115: l_init_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
10116: l_ler_id ben_per_in_ler.ler_id%TYPE;
10117: --
10118: CURSOR c_get_cbr_elig_dates IS
10119: SELECT cqb.*

Line 10116: l_ler_id ben_per_in_ler.ler_id%TYPE;

10112: l_eff_due_date DATE;
10113: l_elcns_made_dt DATE;
10114: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%TYPE;
10115: l_init_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
10116: l_ler_id ben_per_in_ler.ler_id%TYPE;
10117: --
10118: CURSOR c_get_cbr_elig_dates IS
10119: SELECT cqb.*
10120: ,crp.per_in_ler_id

Line 10124: ,ben_per_in_ler pil

10120: ,crp.per_in_ler_id
10121: ,pil.ler_id
10122: FROM ben_cbr_quald_bnf cqb
10123: ,ben_cbr_per_in_ler crp
10124: ,ben_per_in_ler pil
10125: WHERE cqb.quald_bnf_person_id = p_person_id
10126: AND cqb.quald_bnf_flag = 'Y'
10127: AND cqb.pgm_id = NVL(p_pgm_id
10128: ,cqb.pgm_id)

Line 10146: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil

10142: --
10143: CURSOR c_get_init_evt(
10144: p_cbr_quald_bnf_id IN NUMBER) IS
10145: SELECT NULL
10146: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil
10147: WHERE crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
10148: AND crp.per_in_ler_id = pil.per_in_ler_id
10149: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
10150: AND crp.business_group_id = pil.business_group_id

Line 10156: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil

10152: AND crp.init_evt_flag = 'N';
10153: CURSOR c_get_per_in_ler(
10154: p_cbr_quald_bnf_id IN NUMBER) IS
10155: SELECT crp.per_in_ler_id
10156: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil
10157: WHERE crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
10158: AND crp.per_in_ler_id = pil.per_in_ler_id
10159: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
10160: -- AND crp.business_group_id = pil.business_group_id

Line 10168: ,ben_per_in_ler pil

10164: CURSOR c_get_enrt_perd_dates(
10165: p_pgm_id IN NUMBER) IS
10166: SELECT pel.*
10167: FROM ben_pil_elctbl_chc_popl pel
10168: ,ben_per_in_ler pil
10169: WHERE pel.pgm_id = p_pgm_id
10170: AND pel.per_in_ler_id = pil.per_in_ler_id
10171: and pil.person_id = p_person_id
10172: AND pel.business_group_id = p_business_group_id

Line 10190: FROM ben_cbr_per_in_ler crp, ben_ler_f ler, ben_per_in_ler pil

10186: --
10187: CURSOR c_get_dsblity_evt(
10188: p_cbr_quald_bnf_id NUMBER) IS
10189: SELECT crp.*
10190: FROM ben_cbr_per_in_ler crp, ben_ler_f ler, ben_per_in_ler pil
10191: WHERE crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
10192: AND crp.per_in_ler_id = pil.per_in_ler_id
10193: AND pil.ler_id = ler.ler_id
10194: AND ler.typ_cd = 'DSBLTY'

Line 10204: FROM ben_cbr_per_in_ler crp2, ben_per_in_ler pil2

10200: AND ler.business_group_id = pil.business_group_id
10201: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
10202: AND crp.cnt_num =
10203: (SELECT MAX(cnt_num)
10204: FROM ben_cbr_per_in_ler crp2, ben_per_in_ler pil2
10205: WHERE crp2.cbr_quald_bnf_id = p_cbr_quald_bnf_id
10206: AND crp2.per_in_ler_id = pil2.per_in_ler_id
10207: AND pil2.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
10208: AND crp2.business_group_id = p_business_group_id

Line 10219: ,ben_per_in_ler pil

10215: ,p_ptip_id IN NUMBER) IS
10216: SELECT cqb.*
10217: FROM ben_cbr_quald_bnf cqb
10218: ,ben_cbr_per_in_ler crp
10219: ,ben_per_in_ler pil
10220: WHERE cqb.cvrd_emp_person_id = p_cvrd_emp_person_id
10221: AND cqb.quald_bnf_flag = 'Y'
10222: AND l_effective_date BETWEEN cqb.cbr_elig_perd_strt_dt
10223: AND cqb.cbr_elig_perd_end_dt

Line 10257: FROM ben_per_in_ler pil

10253: OR peo.mx_poe_rl IS NOT NULL);
10254: --
10255: CURSOR c_chk_lf_evt IS
10256: SELECT NULL
10257: FROM ben_per_in_ler pil
10258: WHERE pil.person_id = p_person_id
10259: AND pil.business_group_id = p_business_group_id
10260: AND pil.lf_evt_ocrd_dt = l_lf_evt_ocrd_dt
10261: AND pil.ler_id <> l_ler_id

Line 10272: ,ben_per_in_ler pil

10268: ,crp.per_in_ler_id
10269: ,pil.ler_id
10270: FROM ben_cbr_quald_bnf cqb
10271: ,ben_cbr_per_in_ler crp
10272: ,ben_per_in_ler pil
10273: WHERE cqb.quald_bnf_person_id = p_person_id
10274: AND cqb.quald_bnf_flag = 'Y'
10275: AND cqb.pgm_id = p_pgm_id
10276: AND cqb.business_group_id = p_business_group_id

Line 10288: FROM ben_per_in_ler pil

10284: ,p_cbr_elig_end_dt in date
10285: )
10286: IS
10287: SELECT ler.*, pil.lf_evt_ocrd_dt
10288: FROM ben_per_in_ler pil
10289: ,ben_ler_f ler
10290: WHERE pil.ler_id = ler.ler_id
10291: AND pil.business_group_id = p_business_group_id
10292: AND ler.name = 'Assistance Eligible Individual'

Line 10792: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE

10788: --
10789: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE
10790: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10791: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10792: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
10793: --
10794: ,p_mode IN VARCHAR2 DEFAULT NULL
10795: --
10796: ,p_effective_date IN DATE