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.GHR_SF52_DO_UPDATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 2540: per_all_assignments_f asg

2536: l_user_apnt_eff_date date;
2537: CURSOR c_user_apnt_status IS
2538: select ast.user_status,asg.effective_start_date
2539: from per_assignment_status_types ast,
2540: per_all_assignments_f asg
2541: where ast.assignment_status_type_id = asg.assignment_status_type_id
2542: and asg.assignment_id = p_assignment_id
2543: and asg.primary_flag = 'Y'
2544: order by asg.effective_start_date;

Line 2552: per_all_assignments_f asg

2548: l_user_actv_apnt_status per_assignment_status_types.user_status%type;
2549: CURSOR c_user_actv_appt IS
2550: select ast.user_status
2551: from per_assignment_status_types ast,
2552: per_all_assignments_f asg
2553: where ast.assignment_status_type_id = asg.assignment_status_type_id
2554: and asg.assignment_id = p_assignment_id
2555: and asg.primary_flag = 'Y'
2556: and user_status='Active Appointment';

Line 2573: per_all_assignments_f asg

2569:
2570: Cursor c_cur_detail_user_status is
2571: select asg.effective_start_date
2572: from per_assignment_status_types ast,
2573: per_all_assignments_f asg
2574: where asg.assignment_id = p_assignment_id
2575: and ast.assignment_status_type_id = asg.assignment_status_type_id
2576: and ast.user_status='Detail NTE'
2577: and g_effective_date

Line 2596: per_all_assignments_f asg

2592: and gph.table_name = 'PER_ASSIGNMENTS_F'
2593: and gph.effective_date < =
2594: (select asg.effective_start_date
2595: from per_assignment_status_types ast,
2596: per_all_assignments_f asg
2597: where asg.assignment_id = p_assignment_id
2598: and ast.assignment_status_type_id = asg.assignment_status_type_id
2599: and ast.user_status='Detail NTE'
2600: and g_effective_date

Line 2607: per_all_assignments_f asg

2603: order by gph.pa_history_id desc;
2604:
2605: /* select ast.user_status,ast.per_system_status
2606: from per_assignment_status_types ast,
2607: per_all_assignments_f asg
2608: where asg.assignment_id = p_assignment_id
2609: and ast.assignment_status_type_id = asg.assignment_status_type_id
2610: and ast.user_status <> 'Detail NTE'
2611: and asg.effective_start_date <

Line 2614: per_all_assignments_f asg

2610: and ast.user_status <> 'Detail NTE'
2611: and asg.effective_start_date <
2612: (select asg.effective_start_date
2613: from per_assignment_status_types ast,
2614: per_all_assignments_f asg
2615: where asg.assignment_id = p_assignment_id
2616: and ast.assignment_status_type_id = asg.assignment_status_type_id
2617: and ast.user_status='Detail NTE'
2618: and g_effective_date

Line 2884: from per_all_assignments_f asg

2880:
2881: cursor c_update_mode_a is
2882: select asg.effective_start_date ,
2883: asg.effective_end_date
2884: from per_all_assignments_f asg
2885: where asg.assignment_id = p_id
2886: and p_effective_date
2887: between asg.effective_start_date
2888: and asg.effective_end_date;

Line 2893: from per_all_assignments_f asg

2889:
2890: cursor c_update_mode_a1 is
2891: select asg.effective_start_date ,
2892: asg.effective_end_date
2893: from per_all_assignments_f asg
2894: where asg.assignment_id = p_id
2895: and p_effective_date < asg.effective_start_date;
2896:
2897:

Line 3286: from per_all_assignments_f asg

3282:
3283: Cursor c_other_asg is
3284: select asg.assignment_id,
3285: asg.object_version_number
3286: from per_all_assignments_f asg
3287: where asg.person_id = p_pa_request_rec.person_id
3288: and asg.assignment_id <> p_pa_request_rec.employee_assignment_id;
3289:
3290:

Line 3394: from per_all_assignments_f paf

3390: paf.normal_hours,
3391: paf.location_id,
3392: paf.payroll_id,
3393: paf.job_id
3394: from per_all_assignments_f paf
3395: where paf.assignment_id = p_assignment_id
3396: and g_effective_date
3397: between paf.effective_start_date
3398: and paf.effective_end_date;

Line 3488: per_all_assignments_f asg

3484: ast.per_system_status,
3485: asg.effective_start_date
3486: from
3487: per_assignment_status_types ast,
3488: per_all_assignments_f asg
3489: where asg.assignment_id = l_assignment_id
3490: and ast.assignment_status_type_id = asg.assignment_status_type_id
3491: and g_effective_date
3492: between asg.effective_start_date

Line 3649: CURSOR c_get_asg_position(c_assignment_id per_all_assignments_f.assignment_id%type,

3645:
3646:
3647: --Bug 3381960
3648: -- Get Assignment position for the person
3649: CURSOR c_get_asg_position(c_assignment_id per_all_assignments_f.assignment_id%type,
3650: c_effective_date per_all_assignments_f.effective_start_date%type) IS
3651: SELECT position_id
3652: FROM per_all_assignments_f asg
3653: WHERE asg.assignment_id = c_assignment_id

Line 3650: c_effective_date per_all_assignments_f.effective_start_date%type) IS

3646:
3647: --Bug 3381960
3648: -- Get Assignment position for the person
3649: CURSOR c_get_asg_position(c_assignment_id per_all_assignments_f.assignment_id%type,
3650: c_effective_date per_all_assignments_f.effective_start_date%type) IS
3651: SELECT position_id
3652: FROM per_all_assignments_f asg
3653: WHERE asg.assignment_id = c_assignment_id
3654: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 3652: FROM per_all_assignments_f asg

3648: -- Get Assignment position for the person
3649: CURSOR c_get_asg_position(c_assignment_id per_all_assignments_f.assignment_id%type,
3650: c_effective_date per_all_assignments_f.effective_start_date%type) IS
3651: SELECT position_id
3652: FROM per_all_assignments_f asg
3653: WHERE asg.assignment_id = c_assignment_id
3654: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
3655: l_asg_position per_all_assignments_f.position_id%type;
3656:

Line 3655: l_asg_position per_all_assignments_f.position_id%type;

3651: SELECT position_id
3652: FROM per_all_assignments_f asg
3653: WHERE asg.assignment_id = c_assignment_id
3654: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
3655: l_asg_position per_all_assignments_f.position_id%type;
3656:
3657:
3658: --Pradeep
3659: CURSOR cur_get_nte_date IS

Line 3689: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;

3685: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3686:
3687: --bug 4542437
3688: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3689: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3690: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3691: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3692: l_pos_ei_data per_position_extra_info%ROWTYPE;
3693:

Line 3690: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;

3686:
3687: --bug 4542437
3688: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3689: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3690: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3691: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3692: l_pos_ei_data per_position_extra_info%ROWTYPE;
3693:
3694: --Bug # 6127620

Line 6999: from per_all_assignments_f asg

6995: order by ele.element_entry_id,ipv.input_value_id;
6996:
6997: cursor c_business_group (asg_id number, eff_date date) is
6998: select asg.business_group_id
6999: from per_all_assignments_f asg
7000: where asg.assignment_id = asg_id
7001: and eff_date between asg.effective_start_date
7002: and asg.effective_end_date;
7003:

Line 8180: from per_all_assignments_f asg

8176: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
8177:
8178: Cursor c_payroll_id is
8179: select asg.payroll_id
8180: from per_all_assignments_f asg
8181: where asg.assignment_id = p_pa_request_rec.employee_assignment_id;
8182:
8183: Cursor c_equiv_pay_plan is
8184: select gpp.equivalent_pay_plan,gpp.maximum_Step