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 2442: per_all_assignments_f asg

2438: l_user_apnt_eff_date date;
2439: CURSOR c_user_apnt_status IS
2440: select ast.user_status,asg.effective_start_date
2441: from per_assignment_status_types ast,
2442: per_all_assignments_f asg
2443: where ast.assignment_status_type_id = asg.assignment_status_type_id
2444: and asg.assignment_id = p_assignment_id
2445: and asg.primary_flag = 'Y'
2446: order by asg.effective_start_date;

Line 2454: per_all_assignments_f asg

2450: l_user_actv_apnt_status per_assignment_status_types.user_status%type;
2451: CURSOR c_user_actv_appt IS
2452: select ast.user_status
2453: from per_assignment_status_types ast,
2454: per_all_assignments_f asg
2455: where ast.assignment_status_type_id = asg.assignment_status_type_id
2456: and asg.assignment_id = p_assignment_id
2457: and asg.primary_flag = 'Y'
2458: and user_status='Active Appointment';

Line 2680: from per_all_assignments_f asg

2676:
2677: cursor c_update_mode_a is
2678: select asg.effective_start_date ,
2679: asg.effective_end_date
2680: from per_all_assignments_f asg
2681: where asg.assignment_id = p_id
2682: and p_effective_date
2683: between asg.effective_start_date
2684: and asg.effective_end_date;

Line 2689: from per_all_assignments_f asg

2685:
2686: cursor c_update_mode_a1 is
2687: select asg.effective_start_date ,
2688: asg.effective_end_date
2689: from per_all_assignments_f asg
2690: where asg.assignment_id = p_id
2691: and p_effective_date < asg.effective_start_date;
2692:
2693:

Line 3082: from per_all_assignments_f asg

3078:
3079: Cursor c_other_asg is
3080: select asg.assignment_id,
3081: asg.object_version_number
3082: from per_all_assignments_f asg
3083: where asg.person_id = p_pa_request_rec.person_id
3084: and asg.assignment_id <> p_pa_request_rec.employee_assignment_id;
3085:
3086:

Line 3189: from per_all_assignments_f paf

3185: paf.business_group_id,
3186: paf.normal_hours,
3187: paf.location_id,
3188: paf.payroll_id
3189: from per_all_assignments_f paf
3190: where paf.assignment_id = p_assignment_id
3191: and g_effective_date
3192: between paf.effective_start_date
3193: and paf.effective_end_date;

Line 3283: per_all_assignments_f asg

3279: ast.per_system_status,
3280: asg.effective_start_date
3281: from
3282: per_assignment_status_types ast,
3283: per_all_assignments_f asg
3284: where asg.assignment_id = l_assignment_id
3285: and ast.assignment_status_type_id = asg.assignment_status_type_id
3286: and g_effective_date
3287: between asg.effective_start_date

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

3425:
3426:
3427: --Bug 3381960
3428: -- Get Assignment position for the person
3429: CURSOR c_get_asg_position(c_assignment_id per_all_assignments_f.assignment_id%type,
3430: c_effective_date per_all_assignments_f.effective_start_date%type) IS
3431: SELECT position_id
3432: FROM per_all_assignments_f asg
3433: WHERE asg.assignment_id = c_assignment_id

Line 3430: c_effective_date per_all_assignments_f.effective_start_date%type) IS

3426:
3427: --Bug 3381960
3428: -- Get Assignment position for the person
3429: CURSOR c_get_asg_position(c_assignment_id per_all_assignments_f.assignment_id%type,
3430: c_effective_date per_all_assignments_f.effective_start_date%type) IS
3431: SELECT position_id
3432: FROM per_all_assignments_f asg
3433: WHERE asg.assignment_id = c_assignment_id
3434: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 3432: FROM per_all_assignments_f asg

3428: -- Get Assignment position for the person
3429: CURSOR c_get_asg_position(c_assignment_id per_all_assignments_f.assignment_id%type,
3430: c_effective_date per_all_assignments_f.effective_start_date%type) IS
3431: SELECT position_id
3432: FROM per_all_assignments_f asg
3433: WHERE asg.assignment_id = c_assignment_id
3434: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
3435: l_asg_position per_all_assignments_f.position_id%type;
3436:

Line 3435: l_asg_position per_all_assignments_f.position_id%type;

3431: SELECT position_id
3432: FROM per_all_assignments_f asg
3433: WHERE asg.assignment_id = c_assignment_id
3434: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
3435: l_asg_position per_all_assignments_f.position_id%type;
3436:
3437:
3438: --Pradeep
3439: CURSOR cur_get_nte_date IS

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

3468: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3469:
3470: --bug 4542437
3471: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3472: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3473: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3474: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3475: l_pos_ei_data per_position_extra_info%ROWTYPE;
3476: Begin

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

3469:
3470: --bug 4542437
3471: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3472: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3473: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3474: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3475: l_pos_ei_data per_position_extra_info%ROWTYPE;
3476: Begin
3477: --

Line 6723: from per_all_assignments_f asg

6719: order by ele.element_entry_id,ipv.input_value_id;
6720:
6721: cursor c_business_group (asg_id number, eff_date date) is
6722: select asg.business_group_id
6723: from per_all_assignments_f asg
6724: where asg.assignment_id = asg_id
6725: and eff_date between asg.effective_start_date
6726: and asg.effective_end_date;
6727:

Line 7877: from per_all_assignments_f asg

7873: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
7874:
7875: Cursor c_payroll_id is
7876: select asg.payroll_id
7877: from per_all_assignments_f asg
7878: where asg.assignment_id = p_pa_request_rec.employee_assignment_id;
7879:
7880: Cursor c_equiv_pay_plan is
7881: select gpp.equivalent_pay_plan,gpp.maximum_Step