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

Line 625: p_assignment_id per_all_assignments_f.assignment_id%type;

621: IS
622:
623:
624: p_person_id per_all_people_f.person_id%type;
625: p_assignment_id per_all_assignments_f.assignment_id%type;
626: p_assignment_number per_all_assignments_f.assignment_number%type;
627: p_effective_start_date varchar2(10);
628: p_effective_end_date varchar2(10);
629: p_probation_period per_all_assignments_f.probation_period%type;

Line 626: p_assignment_number per_all_assignments_f.assignment_number%type;

622:
623:
624: p_person_id per_all_people_f.person_id%type;
625: p_assignment_id per_all_assignments_f.assignment_id%type;
626: p_assignment_number per_all_assignments_f.assignment_number%type;
627: p_effective_start_date varchar2(10);
628: p_effective_end_date varchar2(10);
629: p_probation_period per_all_assignments_f.probation_period%type;
630: p_probation_units per_all_assignments_f.probation_unit%type;

Line 629: p_probation_period per_all_assignments_f.probation_period%type;

625: p_assignment_id per_all_assignments_f.assignment_id%type;
626: p_assignment_number per_all_assignments_f.assignment_number%type;
627: p_effective_start_date varchar2(10);
628: p_effective_end_date varchar2(10);
629: p_probation_period per_all_assignments_f.probation_period%type;
630: p_probation_units per_all_assignments_f.probation_unit%type;
631: p_organization_id per_all_assignments_f.organization_id%type;
632: p_job_id per_all_assignments_f.job_id%type;
633: p_position_id per_all_assignments_f.position_id%type;

Line 630: p_probation_units per_all_assignments_f.probation_unit%type;

626: p_assignment_number per_all_assignments_f.assignment_number%type;
627: p_effective_start_date varchar2(10);
628: p_effective_end_date varchar2(10);
629: p_probation_period per_all_assignments_f.probation_period%type;
630: p_probation_units per_all_assignments_f.probation_unit%type;
631: p_organization_id per_all_assignments_f.organization_id%type;
632: p_job_id per_all_assignments_f.job_id%type;
633: p_position_id per_all_assignments_f.position_id%type;
634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

Line 631: p_organization_id per_all_assignments_f.organization_id%type;

627: p_effective_start_date varchar2(10);
628: p_effective_end_date varchar2(10);
629: p_probation_period per_all_assignments_f.probation_period%type;
630: p_probation_units per_all_assignments_f.probation_unit%type;
631: p_organization_id per_all_assignments_f.organization_id%type;
632: p_job_id per_all_assignments_f.job_id%type;
633: p_position_id per_all_assignments_f.position_id%type;
634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
635: p_location_id per_all_assignments_f.location_id%type;

Line 632: p_job_id per_all_assignments_f.job_id%type;

628: p_effective_end_date varchar2(10);
629: p_probation_period per_all_assignments_f.probation_period%type;
630: p_probation_units per_all_assignments_f.probation_unit%type;
631: p_organization_id per_all_assignments_f.organization_id%type;
632: p_job_id per_all_assignments_f.job_id%type;
633: p_position_id per_all_assignments_f.position_id%type;
634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
635: p_location_id per_all_assignments_f.location_id%type;
636: p_employment_category per_all_assignments_f.employment_category%type;

Line 633: p_position_id per_all_assignments_f.position_id%type;

629: p_probation_period per_all_assignments_f.probation_period%type;
630: p_probation_units per_all_assignments_f.probation_unit%type;
631: p_organization_id per_all_assignments_f.organization_id%type;
632: p_job_id per_all_assignments_f.job_id%type;
633: p_position_id per_all_assignments_f.position_id%type;
634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
635: p_location_id per_all_assignments_f.location_id%type;
636: p_employment_category per_all_assignments_f.employment_category%type;
637: p_business_group_id per_all_assignments_f.business_group_id%type;

Line 634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

630: p_probation_units per_all_assignments_f.probation_unit%type;
631: p_organization_id per_all_assignments_f.organization_id%type;
632: p_job_id per_all_assignments_f.job_id%type;
633: p_position_id per_all_assignments_f.position_id%type;
634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
635: p_location_id per_all_assignments_f.location_id%type;
636: p_employment_category per_all_assignments_f.employment_category%type;
637: p_business_group_id per_all_assignments_f.business_group_id%type;
638: p_normal_hours per_all_assignments_f.normal_hours%type;

Line 635: p_location_id per_all_assignments_f.location_id%type;

631: p_organization_id per_all_assignments_f.organization_id%type;
632: p_job_id per_all_assignments_f.job_id%type;
633: p_position_id per_all_assignments_f.position_id%type;
634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
635: p_location_id per_all_assignments_f.location_id%type;
636: p_employment_category per_all_assignments_f.employment_category%type;
637: p_business_group_id per_all_assignments_f.business_group_id%type;
638: p_normal_hours per_all_assignments_f.normal_hours%type;
639: p_frequency per_all_assignments_f.frequency%type;

Line 636: p_employment_category per_all_assignments_f.employment_category%type;

632: p_job_id per_all_assignments_f.job_id%type;
633: p_position_id per_all_assignments_f.position_id%type;
634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
635: p_location_id per_all_assignments_f.location_id%type;
636: p_employment_category per_all_assignments_f.employment_category%type;
637: p_business_group_id per_all_assignments_f.business_group_id%type;
638: p_normal_hours per_all_assignments_f.normal_hours%type;
639: p_frequency per_all_assignments_f.frequency%type;
640: p_grade_id per_all_assignments_f.grade_id%type;

Line 637: p_business_group_id per_all_assignments_f.business_group_id%type;

633: p_position_id per_all_assignments_f.position_id%type;
634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
635: p_location_id per_all_assignments_f.location_id%type;
636: p_employment_category per_all_assignments_f.employment_category%type;
637: p_business_group_id per_all_assignments_f.business_group_id%type;
638: p_normal_hours per_all_assignments_f.normal_hours%type;
639: p_frequency per_all_assignments_f.frequency%type;
640: p_grade_id per_all_assignments_f.grade_id%type;
641: p_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 638: p_normal_hours per_all_assignments_f.normal_hours%type;

634: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
635: p_location_id per_all_assignments_f.location_id%type;
636: p_employment_category per_all_assignments_f.employment_category%type;
637: p_business_group_id per_all_assignments_f.business_group_id%type;
638: p_normal_hours per_all_assignments_f.normal_hours%type;
639: p_frequency per_all_assignments_f.frequency%type;
640: p_grade_id per_all_assignments_f.grade_id%type;
641: p_supervisor_id per_all_assignments_f.supervisor_id%type;
642: p_act_termn_date varchar2(10);

Line 639: p_frequency per_all_assignments_f.frequency%type;

635: p_location_id per_all_assignments_f.location_id%type;
636: p_employment_category per_all_assignments_f.employment_category%type;
637: p_business_group_id per_all_assignments_f.business_group_id%type;
638: p_normal_hours per_all_assignments_f.normal_hours%type;
639: p_frequency per_all_assignments_f.frequency%type;
640: p_grade_id per_all_assignments_f.grade_id%type;
641: p_supervisor_id per_all_assignments_f.supervisor_id%type;
642: p_act_termn_date varchar2(10);
643: p_final_prcs_date varchar2(10);

Line 640: p_grade_id per_all_assignments_f.grade_id%type;

636: p_employment_category per_all_assignments_f.employment_category%type;
637: p_business_group_id per_all_assignments_f.business_group_id%type;
638: p_normal_hours per_all_assignments_f.normal_hours%type;
639: p_frequency per_all_assignments_f.frequency%type;
640: p_grade_id per_all_assignments_f.grade_id%type;
641: p_supervisor_id per_all_assignments_f.supervisor_id%type;
642: p_act_termn_date varchar2(10);
643: p_final_prcs_date varchar2(10);
644: p_primary_flag per_all_assignments_f.primary_flag%type;

Line 641: p_supervisor_id per_all_assignments_f.supervisor_id%type;

637: p_business_group_id per_all_assignments_f.business_group_id%type;
638: p_normal_hours per_all_assignments_f.normal_hours%type;
639: p_frequency per_all_assignments_f.frequency%type;
640: p_grade_id per_all_assignments_f.grade_id%type;
641: p_supervisor_id per_all_assignments_f.supervisor_id%type;
642: p_act_termn_date varchar2(10);
643: p_final_prcs_date varchar2(10);
644: p_primary_flag per_all_assignments_f.primary_flag%type;
645:

Line 644: p_primary_flag per_all_assignments_f.primary_flag%type;

640: p_grade_id per_all_assignments_f.grade_id%type;
641: p_supervisor_id per_all_assignments_f.supervisor_id%type;
642: p_act_termn_date varchar2(10);
643: p_final_prcs_date varchar2(10);
644: p_primary_flag per_all_assignments_f.primary_flag%type;
645:
646: l_record_counter Number :=0;
647: l_file_counter Number :=0;
648: r Number :=1;

Line 691: per_all_assignments_f pas,

687:
688: primary_flag
689:
690: FROM
691: per_all_assignments_f pas,
692: per_periods_of_service pos,
693: per_periods_of_placement pop
694: WHERE pas.person_id = pop.person_id (+)
695: AND pas.person_id = pos.person_id (+)