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 PER_ALL_PEOPLE_F

Line 2324: l_per_rec per_all_people_f%ROWTYPE;

2320: l_subtract_date DATE;
2321: l_start_date DATE;
2322: l_result NUMBER;
2323: l_pps_rec per_periods_of_service%ROWTYPE;
2324: l_per_rec per_all_people_f%ROWTYPE;
2325: l_dummy_num NUMBER;
2326: l_aei_rec per_assignment_extra_info%ROWTYPE;
2327: l_ass_rec per_all_assignments_f%ROWTYPE;
2328: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

Line 2584: ,p_per_row IN per_all_people_f%ROWTYPE

2580: END los_calculation;
2581: --
2582: FUNCTION age_calculation(
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

Line 2620: l_per_rec per_all_people_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;
2619: l_loc_rec hr_locations_all%ROWTYPE;
2620: l_per_rec per_all_people_f%ROWTYPE;
2621: l_person_id NUMBER;
2622: l_jurisdiction_code VARCHAR2(30);
2623: l_aei_rec per_assignment_extra_info%ROWTYPE;
2624: --

Line 2629: FROM per_contact_relationships ctr, per_all_people_f per

2625: --bug#3274130 - added date condition for relationship to pick the right spouse
2626: CURSOR c_per_spouse IS
2627: SELECT per.person_id
2628: ,per.date_of_birth
2629: FROM per_contact_relationships ctr, per_all_people_f per
2630: WHERE ctr.person_id = p_person_id
2631: AND per.person_id = ctr.contact_person_id
2632: AND ctr.personal_flag = 'Y'
2633: AND ctr.contact_type = 'S'

Line 2642: FROM per_contact_relationships ctr, per_all_people_f per

2638: --
2639: CURSOR c_per_depen_first IS
2640: SELECT per.person_id
2641: ,per.date_of_birth
2642: FROM per_contact_relationships ctr, per_all_people_f per
2643: WHERE ctr.person_id = p_person_id
2644: AND per.person_id = ctr.contact_person_id
2645: AND ctr.personal_flag = 'Y'
2646: AND ctr.dependent_flag = 'Y'

Line 2653: FROM per_contact_relationships ctr, per_all_people_f per

2649: --
2650: CURSOR c_per_child_first IS
2651: SELECT per.person_id
2652: ,per.date_of_birth
2653: FROM per_contact_relationships ctr, per_all_people_f per
2654: WHERE ctr.person_id = p_person_id
2655: AND per.person_id = ctr.contact_person_id
2656: AND ctr.personal_flag = 'Y'
2657: AND ctr.contact_type IN ('C', 'O', 'A', 'T')

Line 2664: FROM per_contact_relationships ctr, per_all_people_f per

2660: --
2661: CURSOR c_per_depen_oldest IS
2662: SELECT per.person_id
2663: ,per.date_of_birth
2664: FROM per_contact_relationships ctr, per_all_people_f per
2665: WHERE ctr.person_id = p_person_id
2666: AND per.person_id = ctr.contact_person_id
2667: AND ctr.personal_flag = 'Y'
2668: AND ctr.dependent_flag = 'Y'

Line 2676: FROM per_contact_relationships ctr, per_all_people_f per

2672: --
2673: CURSOR c_per_child_oldest IS
2674: SELECT per.person_id
2675: ,per.date_of_birth
2676: FROM per_contact_relationships ctr, per_all_people_f per
2677: WHERE ctr.person_id = p_person_id
2678: AND per.person_id = ctr.contact_person_id
2679: AND ctr.personal_flag = 'Y'
2680: AND ctr.contact_type IN ('C', 'O', 'A', 'T')

Line 2688: FROM per_contact_relationships ctr, per_all_people_f per

2684: --
2685: CURSOR c_per_depen_young IS
2686: SELECT per.person_id
2687: ,per.date_of_birth
2688: FROM per_contact_relationships ctr, per_all_people_f per
2689: WHERE ctr.person_id = p_person_id
2690: AND per.person_id = ctr.contact_person_id
2691: AND ctr.personal_flag = 'Y'
2692: AND ctr.dependent_flag = 'Y'

Line 2700: FROM per_contact_relationships ctr, per_all_people_f per

2696: --
2697: CURSOR c_per_child_young IS
2698: SELECT per.person_id
2699: ,per.date_of_birth
2700: FROM per_contact_relationships ctr, per_all_people_f per
2701: WHERE ctr.person_id = p_person_id
2702: AND per.person_id = ctr.contact_person_id
2703: AND ctr.personal_flag = 'Y'
2704: AND ctr.contact_type IN ('C', 'O', 'A', 'T')

Line 4497: ,p_per_row IN per_all_people_f%ROWTYPE

4493: --
4494: PROCEDURE calculate_age
4495: (p_calculate_only_mode in boolean default false
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

Line 6758: ,p_per_row IN per_all_people_f%ROWTYPE

6754: --
6755: PROCEDURE calculate_comb_age_and_los
6756: (p_calculate_only_mode in boolean default false
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

Line 10789: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE

10785: ,p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
10786: --
10787: -- Context info
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: --