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_DETERMINE_ACTIVITY_BASE_RT dependencies on PER_ALL_ASSIGNMENTS_F

Line 445: ,p_asg_row in per_all_assignments_f%rowtype

441: (p_currepe_row in ben_determine_rates.g_curr_epe_rec
442: := ben_determine_rates.g_def_curr_epe_rec
443: ,p_per_row in per_all_people_F%rowtype
444: := ben_determine_rates.g_def_curr_per_rec
445: ,p_asg_row in per_all_assignments_f%rowtype
446: := ben_determine_rates.g_def_curr_asg_rec
447: ,p_ast_row in per_assignment_status_types%rowtype
448: := ben_determine_rates.g_def_curr_ast_rec
449: ,p_adr_row in per_addresses%rowtype

Line 584: l_assignment_id per_all_assignments_f.assignment_id%type;

580: l_ultmt_lwr_lmt_calc_rl number;
581: l_vr_ann_mn_elcn_val number;
582: l_vr_ann_mx_elcn_val number;
583: l_enrt_bnft_id number := p_enrt_bnft_id ;
584: l_assignment_id per_all_assignments_f.assignment_id%type;
585: l_payroll_id per_all_assignments_f.payroll_id%type;
586: l_organization_id per_all_assignments_f.organization_id%type;
587: --
588: -- Bug 4637525

Line 585: l_payroll_id per_all_assignments_f.payroll_id%type;

581: l_vr_ann_mn_elcn_val number;
582: l_vr_ann_mx_elcn_val number;
583: l_enrt_bnft_id number := p_enrt_bnft_id ;
584: l_assignment_id per_all_assignments_f.assignment_id%type;
585: l_payroll_id per_all_assignments_f.payroll_id%type;
586: l_organization_id per_all_assignments_f.organization_id%type;
587: --
588: -- Bug 4637525
589: l_cwb_dflt_val number;

Line 586: l_organization_id per_all_assignments_f.organization_id%type;

582: l_vr_ann_mx_elcn_val number;
583: l_enrt_bnft_id number := p_enrt_bnft_id ;
584: l_assignment_id per_all_assignments_f.assignment_id%type;
585: l_payroll_id per_all_assignments_f.payroll_id%type;
586: l_organization_id per_all_assignments_f.organization_id%type;
587: --
588: -- Bug 4637525
589: l_cwb_dflt_val number;
590: l_cwb_incrmt_elcn_val number;

Line 639: from per_all_assignments_f asg,hr_locations_all loc

635: select asg.assignment_id,
636: asg.organization_id,
637: asg.payroll_id,
638: loc.region_2
639: from per_all_assignments_f asg,hr_locations_all loc
640: where asg.person_id = p_person_id
641: and asg.assignment_type <> 'C'
642: and asg.primary_flag = 'Y'
643: and asg.location_id = loc.location_id(+)

Line 1042: from hr_locations_all loc,per_all_assignments_f asg

1038:
1039: Cursor c_state
1040: is
1041: select region_2
1042: from hr_locations_all loc,per_all_assignments_f asg
1043: where loc.location_id = asg.location_id
1044: and asg.assignment_type <> 'C'
1045: and asg.person_id = p_person_id
1046: and asg.primary_flag = 'Y'