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 462: ,p_asg_row in per_all_assignments_f%rowtype

458: (p_currepe_row in ben_determine_rates.g_curr_epe_rec
459: := ben_determine_rates.g_def_curr_epe_rec
460: ,p_per_row in per_all_people_F%rowtype
461: := ben_determine_rates.g_def_curr_per_rec
462: ,p_asg_row in per_all_assignments_f%rowtype
463: := ben_determine_rates.g_def_curr_asg_rec
464: ,p_ast_row in per_assignment_status_types%rowtype
465: := ben_determine_rates.g_def_curr_ast_rec
466: ,p_adr_row in per_addresses%rowtype

Line 601: l_assignment_id per_all_assignments_f.assignment_id%type;

597: l_ultmt_lwr_lmt_calc_rl number;
598: l_vr_ann_mn_elcn_val number;
599: l_vr_ann_mx_elcn_val number;
600: l_enrt_bnft_id number := p_enrt_bnft_id ;
601: l_assignment_id per_all_assignments_f.assignment_id%type;
602: l_payroll_id per_all_assignments_f.payroll_id%type;
603: l_organization_id per_all_assignments_f.organization_id%type;
604: --
605: -- Bug 4637525

Line 602: l_payroll_id per_all_assignments_f.payroll_id%type;

598: l_vr_ann_mn_elcn_val number;
599: l_vr_ann_mx_elcn_val number;
600: l_enrt_bnft_id number := p_enrt_bnft_id ;
601: l_assignment_id per_all_assignments_f.assignment_id%type;
602: l_payroll_id per_all_assignments_f.payroll_id%type;
603: l_organization_id per_all_assignments_f.organization_id%type;
604: --
605: -- Bug 4637525
606: l_cwb_dflt_val number;

Line 603: l_organization_id per_all_assignments_f.organization_id%type;

599: l_vr_ann_mx_elcn_val number;
600: l_enrt_bnft_id number := p_enrt_bnft_id ;
601: l_assignment_id per_all_assignments_f.assignment_id%type;
602: l_payroll_id per_all_assignments_f.payroll_id%type;
603: l_organization_id per_all_assignments_f.organization_id%type;
604: --
605: -- Bug 4637525
606: l_cwb_dflt_val number;
607: l_cwb_incrmt_elcn_val number;

Line 656: from per_all_assignments_f asg,hr_locations_all loc

652: select asg.assignment_id,
653: asg.organization_id,
654: asg.payroll_id,
655: loc.region_2
656: from per_all_assignments_f asg,hr_locations_all loc
657: where asg.person_id = p_person_id
658: and asg.assignment_type <> 'C'
659: and asg.primary_flag = 'Y'
660: and asg.location_id = loc.location_id(+)

Line 1059: from hr_locations_all loc,per_all_assignments_f asg

1055:
1056: Cursor c_state
1057: is
1058: select region_2
1059: from hr_locations_all loc,per_all_assignments_f asg
1060: where loc.location_id = asg.location_id
1061: and asg.assignment_type <> 'C'
1062: and asg.person_id = p_person_id
1063: and asg.primary_flag = 'Y'