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 2323: l_per_rec per_all_people_f%ROWTYPE;

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

Line 2583: ,p_per_row IN per_all_people_f%ROWTYPE

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

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

Line 2628: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2641: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2652: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2663: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2675: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2687: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2699: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 4496: ,p_per_row IN per_all_people_f%ROWTYPE

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

Line 6757: ,p_per_row IN per_all_people_f%ROWTYPE

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

Line 10716: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE

10712: ,p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
10713: --
10714: -- Context info
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: --