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 394: p_assignment_id per_all_assignments_f.assignment_id%type;

390: IS
391:
392:
393: p_person_id per_all_people_f.person_id%type;
394: p_assignment_id per_all_assignments_f.assignment_id%type;
395: p_assignment_number per_all_assignments_f.assignment_number%type;
396: p_effective_start_date varchar2(10);
397: p_effective_end_date varchar2(10);
398: p_probation_period per_all_assignments_f.probation_period%type;

Line 395: p_assignment_number per_all_assignments_f.assignment_number%type;

391:
392:
393: p_person_id per_all_people_f.person_id%type;
394: p_assignment_id per_all_assignments_f.assignment_id%type;
395: p_assignment_number per_all_assignments_f.assignment_number%type;
396: p_effective_start_date varchar2(10);
397: p_effective_end_date varchar2(10);
398: p_probation_period per_all_assignments_f.probation_period%type;
399: p_probation_units per_all_assignments_f.probation_unit%type;

Line 398: p_probation_period per_all_assignments_f.probation_period%type;

394: p_assignment_id per_all_assignments_f.assignment_id%type;
395: p_assignment_number per_all_assignments_f.assignment_number%type;
396: p_effective_start_date varchar2(10);
397: p_effective_end_date varchar2(10);
398: p_probation_period per_all_assignments_f.probation_period%type;
399: p_probation_units per_all_assignments_f.probation_unit%type;
400: p_organization_id per_all_assignments_f.organization_id%type;
401: p_job_id per_all_assignments_f.job_id%type;
402: p_position_id per_all_assignments_f.position_id%type;

Line 399: p_probation_units per_all_assignments_f.probation_unit%type;

395: p_assignment_number per_all_assignments_f.assignment_number%type;
396: p_effective_start_date varchar2(10);
397: p_effective_end_date varchar2(10);
398: p_probation_period per_all_assignments_f.probation_period%type;
399: p_probation_units per_all_assignments_f.probation_unit%type;
400: p_organization_id per_all_assignments_f.organization_id%type;
401: p_job_id per_all_assignments_f.job_id%type;
402: p_position_id per_all_assignments_f.position_id%type;
403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

Line 400: p_organization_id per_all_assignments_f.organization_id%type;

396: p_effective_start_date varchar2(10);
397: p_effective_end_date varchar2(10);
398: p_probation_period per_all_assignments_f.probation_period%type;
399: p_probation_units per_all_assignments_f.probation_unit%type;
400: p_organization_id per_all_assignments_f.organization_id%type;
401: p_job_id per_all_assignments_f.job_id%type;
402: p_position_id per_all_assignments_f.position_id%type;
403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
404: p_location_id per_all_assignments_f.location_id%type;

Line 401: p_job_id per_all_assignments_f.job_id%type;

397: p_effective_end_date varchar2(10);
398: p_probation_period per_all_assignments_f.probation_period%type;
399: p_probation_units per_all_assignments_f.probation_unit%type;
400: p_organization_id per_all_assignments_f.organization_id%type;
401: p_job_id per_all_assignments_f.job_id%type;
402: p_position_id per_all_assignments_f.position_id%type;
403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
404: p_location_id per_all_assignments_f.location_id%type;
405: p_employment_category per_all_assignments_f.employment_category%type;

Line 402: p_position_id per_all_assignments_f.position_id%type;

398: p_probation_period per_all_assignments_f.probation_period%type;
399: p_probation_units per_all_assignments_f.probation_unit%type;
400: p_organization_id per_all_assignments_f.organization_id%type;
401: p_job_id per_all_assignments_f.job_id%type;
402: p_position_id per_all_assignments_f.position_id%type;
403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
404: p_location_id per_all_assignments_f.location_id%type;
405: p_employment_category per_all_assignments_f.employment_category%type;
406: p_business_group_id per_all_assignments_f.business_group_id%type;

Line 403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

399: p_probation_units per_all_assignments_f.probation_unit%type;
400: p_organization_id per_all_assignments_f.organization_id%type;
401: p_job_id per_all_assignments_f.job_id%type;
402: p_position_id per_all_assignments_f.position_id%type;
403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
404: p_location_id per_all_assignments_f.location_id%type;
405: p_employment_category per_all_assignments_f.employment_category%type;
406: p_business_group_id per_all_assignments_f.business_group_id%type;
407: p_normal_hours per_all_assignments_f.normal_hours%type;

Line 404: p_location_id per_all_assignments_f.location_id%type;

400: p_organization_id per_all_assignments_f.organization_id%type;
401: p_job_id per_all_assignments_f.job_id%type;
402: p_position_id per_all_assignments_f.position_id%type;
403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
404: p_location_id per_all_assignments_f.location_id%type;
405: p_employment_category per_all_assignments_f.employment_category%type;
406: p_business_group_id per_all_assignments_f.business_group_id%type;
407: p_normal_hours per_all_assignments_f.normal_hours%type;
408: p_frequency per_all_assignments_f.frequency%type;

Line 405: p_employment_category per_all_assignments_f.employment_category%type;

401: p_job_id per_all_assignments_f.job_id%type;
402: p_position_id per_all_assignments_f.position_id%type;
403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
404: p_location_id per_all_assignments_f.location_id%type;
405: p_employment_category per_all_assignments_f.employment_category%type;
406: p_business_group_id per_all_assignments_f.business_group_id%type;
407: p_normal_hours per_all_assignments_f.normal_hours%type;
408: p_frequency per_all_assignments_f.frequency%type;
409: p_grade_id per_all_assignments_f.grade_id%type;

Line 406: p_business_group_id per_all_assignments_f.business_group_id%type;

402: p_position_id per_all_assignments_f.position_id%type;
403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
404: p_location_id per_all_assignments_f.location_id%type;
405: p_employment_category per_all_assignments_f.employment_category%type;
406: p_business_group_id per_all_assignments_f.business_group_id%type;
407: p_normal_hours per_all_assignments_f.normal_hours%type;
408: p_frequency per_all_assignments_f.frequency%type;
409: p_grade_id per_all_assignments_f.grade_id%type;
410: p_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 407: p_normal_hours per_all_assignments_f.normal_hours%type;

403: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
404: p_location_id per_all_assignments_f.location_id%type;
405: p_employment_category per_all_assignments_f.employment_category%type;
406: p_business_group_id per_all_assignments_f.business_group_id%type;
407: p_normal_hours per_all_assignments_f.normal_hours%type;
408: p_frequency per_all_assignments_f.frequency%type;
409: p_grade_id per_all_assignments_f.grade_id%type;
410: p_supervisor_id per_all_assignments_f.supervisor_id%type;
411: p_act_termn_date varchar2(10);

Line 408: p_frequency per_all_assignments_f.frequency%type;

404: p_location_id per_all_assignments_f.location_id%type;
405: p_employment_category per_all_assignments_f.employment_category%type;
406: p_business_group_id per_all_assignments_f.business_group_id%type;
407: p_normal_hours per_all_assignments_f.normal_hours%type;
408: p_frequency per_all_assignments_f.frequency%type;
409: p_grade_id per_all_assignments_f.grade_id%type;
410: p_supervisor_id per_all_assignments_f.supervisor_id%type;
411: p_act_termn_date varchar2(10);
412: p_final_prcs_date varchar2(10);

Line 409: p_grade_id per_all_assignments_f.grade_id%type;

405: p_employment_category per_all_assignments_f.employment_category%type;
406: p_business_group_id per_all_assignments_f.business_group_id%type;
407: p_normal_hours per_all_assignments_f.normal_hours%type;
408: p_frequency per_all_assignments_f.frequency%type;
409: p_grade_id per_all_assignments_f.grade_id%type;
410: p_supervisor_id per_all_assignments_f.supervisor_id%type;
411: p_act_termn_date varchar2(10);
412: p_final_prcs_date varchar2(10);
413:

Line 410: p_supervisor_id per_all_assignments_f.supervisor_id%type;

406: p_business_group_id per_all_assignments_f.business_group_id%type;
407: p_normal_hours per_all_assignments_f.normal_hours%type;
408: p_frequency per_all_assignments_f.frequency%type;
409: p_grade_id per_all_assignments_f.grade_id%type;
410: p_supervisor_id per_all_assignments_f.supervisor_id%type;
411: p_act_termn_date varchar2(10);
412: p_final_prcs_date varchar2(10);
413:
414:

Line 448: per_all_assignments_f pas,

444: then to_char(pos.ACTUAL_TERMINATION_DATE,'YYYY-MM-DD')
445: when (pas.person_id = pop.person_id and pas.effective_end_date = pop.actual_termination_date) then to_char(pop.ACTUAL_TERMINATION_DATE,'YYYY-MM-DD') end
446:
447: FROM
448: per_all_assignments_f pas,
449: per_periods_of_service pos,
450: per_periods_of_placement pop
451: WHERE pas.person_id = pop.person_id (+)
452: AND pas.person_id = pos.person_id (+)