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.HR_EX_EMPLOYEE_API dependencies on PER_ASSIGNMENTS_F

Line 30: from per_assignments_f paf

26: Select 'X'
27: into v_dummy
28: from sys.dual
29: where exists (select 'Assignments Exist'
30: from per_assignments_f paf
31: where paf.supervisor_id = p_person_id
32: -- Code changes for Bug#13869378 Starts here
33: and (paf.business_group_id + 0 = p_business_group_id
34: OR NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

Line 621: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;

617: l_event_warning boolean := FALSE;
618: l_interview_warning boolean := FALSE;
619: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
620: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
621: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
622: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
623: l_recruiter_warning boolean := FALSE;
624: l_review_warning boolean := FALSE;
625: l_supervisor_warning boolean := FALSE;

Line 622: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;

618: l_interview_warning boolean := FALSE;
619: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
620: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
621: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
622: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
623: l_recruiter_warning boolean := FALSE;
624: l_review_warning boolean := FALSE;
625: l_supervisor_warning boolean := FALSE;
626: l_dod_warning boolean := FALSE;

Line 635: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;

631: --
632: -- 120.2 (END)
633: --
634: --
635: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
636: l_business_group_id per_assignments_f.business_group_id%TYPE;
637: l_comment_id per_assignments_f.comment_id%TYPE;
638: l_cr_asg_future_changes_warn boolean := FALSE;
639: l_cr_entries_changed_warn varchar2(1) := 'N';

Line 636: l_business_group_id per_assignments_f.business_group_id%TYPE;

632: -- 120.2 (END)
633: --
634: --
635: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
636: l_business_group_id per_assignments_f.business_group_id%TYPE;
637: l_comment_id per_assignments_f.comment_id%TYPE;
638: l_cr_asg_future_changes_warn boolean := FALSE;
639: l_cr_entries_changed_warn varchar2(1) := 'N';
640: l_pay_proposal_warn boolean := FALSE;

Line 637: l_comment_id per_assignments_f.comment_id%TYPE;

633: --
634: --
635: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
636: l_business_group_id per_assignments_f.business_group_id%TYPE;
637: l_comment_id per_assignments_f.comment_id%TYPE;
638: l_cr_asg_future_changes_warn boolean := FALSE;
639: l_cr_entries_changed_warn varchar2(1) := 'N';
640: l_pay_proposal_warn boolean := FALSE;
641: l_current_applicant_flag varchar2(1);

Line 646: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

642: l_current_emp_or_apl_flag varchar2(1);
643: l_current_employee_flag varchar2(1);
644: l_dob_null_warning boolean;
645: l_effective_date date;
646: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
647: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
648: l_employee_number per_all_people_f.employee_number%TYPE;
649: l_applicant_number per_people_f.applicant_number%TYPE;
650: l_npw_number per_people_f.npw_number%TYPE;

Line 647: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

643: l_current_employee_flag varchar2(1);
644: l_dob_null_warning boolean;
645: l_effective_date date;
646: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
647: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
648: l_employee_number per_all_people_f.employee_number%TYPE;
649: l_applicant_number per_people_f.applicant_number%TYPE;
650: l_npw_number per_people_f.npw_number%TYPE;
651: l_exists varchar2(1);

Line 654: l_max_tpe_end_date per_assignments_f.effective_end_date%TYPE;

650: l_npw_number per_people_f.npw_number%TYPE;
651: l_exists varchar2(1);
652: l_full_name per_all_people_f.full_name%TYPE;
653: l_legislation_code per_business_groups.legislation_code%TYPE;
654: l_max_tpe_end_date per_assignments_f.effective_end_date%TYPE;
655: l_name_combination_warning boolean;
656: l_orig_hire_warning boolean;
657: l_per_object_version_number per_assignments_f.object_version_number%TYPE;
658: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 657: l_per_object_version_number per_assignments_f.object_version_number%TYPE;

653: l_legislation_code per_business_groups.legislation_code%TYPE;
654: l_max_tpe_end_date per_assignments_f.effective_end_date%TYPE;
655: l_name_combination_warning boolean;
656: l_orig_hire_warning boolean;
657: l_per_object_version_number per_assignments_f.object_version_number%TYPE;
658: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
659: l_person_id per_all_people_f.person_id%TYPE;
660: l_person_type_id per_all_people_f.person_type_id%TYPE;
661: l_person_type_id1 per_all_people_f.person_type_id%TYPE;

Line 726: from per_assignments_f asg

722: --
723: cursor csr_get_asgs_to_terminate is
724: select asg.assignment_id
725: , asg.object_version_number
726: from per_assignments_f asg
727: where asg.period_of_service_id = p_period_of_service_id
728: and l_actual_termination_date + 1 between asg.effective_start_date
729: and asg.effective_end_date
730: order by asg.primary_flag;

Line 757: ,per_assignments_f asg

753: --
754: cursor csr_get_max_tpe_end_date is
755: select max(tpe.end_date)
756: from per_time_periods tpe
757: ,per_assignments_f asg
758: where asg.period_of_service_id = p_period_of_service_id
759: and l_actual_termination_date between asg.effective_start_date
760: and asg.effective_end_date
761: and asg.payroll_id is not null

Line 2174: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

2170: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
2171: l_cr_asg_future_changes_warn boolean := FALSE;
2172: l_cr_entries_changed_warn varchar2(1) := 'N';
2173: l_cr_org_now_no_manager_warn boolean := FALSE;
2174: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2175: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2176: l_exists varchar2(1);
2177: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
2178: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 2175: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

2171: l_cr_asg_future_changes_warn boolean := FALSE;
2172: l_cr_entries_changed_warn varchar2(1) := 'N';
2173: l_cr_org_now_no_manager_warn boolean := FALSE;
2174: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2175: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2176: l_exists varchar2(1);
2177: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
2178: l_legislation_code per_business_groups.legislation_code%TYPE;
2179: l_object_version_number per_periods_of_service.object_version_number%TYPE;

Line 2802: per_assignments_f asg

2798: WHERE exists
2799: (SELECT null
2800: FROM pay_payroll_actions pac,
2801: pay_assignment_actions act,
2802: per_assignments_f asg
2803: WHERE asg.person_id = p_person_id
2804: AND act.assignment_id = asg.assignment_id
2805: AND pac.payroll_action_id = act.payroll_action_id
2806: AND pac.action_type NOT IN ('X','BEE')

Line 2822: per_assignments_f asg

2818: WHERE exists
2819: (SELECT null
2820: FROM pay_payroll_actions pac,
2821: pay_assignment_actions act,
2822: per_assignments_f asg
2823: WHERE asg.person_id = p_person_id
2824: AND act.assignment_id = asg.assignment_id
2825: AND pac.payroll_action_id = act.payroll_action_id
2826: AND pac.action_type <> 'BEE'