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 713: ,p_pil_row IN ben_per_in_ler%ROWTYPE

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

Line 954: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE

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

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

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

Line 1121: FROM ben_elig_per_f pep, ben_per_in_ler pil

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

Line 2299: ,p_pil_row IN ben_per_in_ler%ROWTYPE

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

Line 2586: ,p_pil_row IN ben_per_in_ler%ROWTYPE

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

Line 2613: l_pil_rec ben_per_in_ler%ROWTYPE;

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

Line 3052: l_pil_rec ben_per_in_ler%ROWTYPE;

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

Line 3399: l_pil_rec ben_per_in_ler%ROWTYPE;

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

Line 3771: ,p_pil_row IN ben_per_in_ler%ROWTYPE

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

Line 4499: ,p_pil_row IN ben_per_in_ler%ROWTYPE

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

Line 5455: ,p_pil_row IN ben_per_in_ler%ROWTYPE

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

Line 6760: ,p_pil_row IN ben_per_in_ler%ROWTYPE

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

Line 7596: ,p_pil_row IN ben_per_in_ler%ROWTYPE

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

Line 8398: ,p_pil_row IN ben_per_in_ler%ROWTYPE

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

Line 9768: l_cbr_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;

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

Line 10107: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;

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

Line 10114: l_init_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

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

Line 10115: l_ler_id ben_per_in_ler.ler_id%TYPE;

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

Line 10123: ,ben_per_in_ler pil

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

Line 10145: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil

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

Line 10155: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil

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

Line 10167: ,ben_per_in_ler pil

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

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

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

Line 10203: FROM ben_cbr_per_in_ler crp2, ben_per_in_ler pil2

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

Line 10218: ,ben_per_in_ler pil

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

Line 10256: FROM ben_per_in_ler pil

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

Line 10271: ,ben_per_in_ler pil

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

Line 10719: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE

10715: --
10716: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE
10717: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10718: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10719: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
10720: --
10721: ,p_mode IN VARCHAR2 DEFAULT NULL
10722: --
10723: ,p_effective_date IN DATE