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_RIR_WF dependencies on PER_PERIODS_OF_SERVICE

Line 870: from per_periods_of_service

866: p_prd_service_id varchar2(100);
867:
868: cursor csr_person_id(p_prd_service_id varchar2,p_date date) is
869: select distinct person_id
870: from per_periods_of_service
871: where period_of_service_id = p_prd_service_id
872: and p_date between date_start and nvl(actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'));
873:
874:

Line 1468: per_periods_of_service pos,

1464: then to_char(pos.ACTUAL_TERMINATION_DATE,''YYYY-MM-DD'')
1465: 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 as "ACTUAL_TERMINATION_DATE"
1466:
1467: FROM per_all_assignments_f pas,
1468: per_periods_of_service pos,
1469: per_periods_of_placement pop
1470: WHERE pas.person_id = pop.person_id (+)
1471: AND pas.person_id = pos.person_id (+)
1472: AND pas.assignment_id = :1

Line 2134: p_final_process_date per_periods_of_service.final_process_date%type;

2130: p_normal_hours per_all_assignments_f.normal_hours%type;
2131: p_frequency per_all_assignments_f.frequency%type;
2132: p_grade_id per_all_assignments_f.grade_id%type;
2133: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2134: p_final_process_date per_periods_of_service.final_process_date%type;
2135: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2136:
2137: -- data required for message from table
2138: p_person_id_t per_all_assignments_f.person_id%type;

Line 2135: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;

2131: p_frequency per_all_assignments_f.frequency%type;
2132: p_grade_id per_all_assignments_f.grade_id%type;
2133: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2134: p_final_process_date per_periods_of_service.final_process_date%type;
2135: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2136:
2137: -- data required for message from table
2138: p_person_id_t per_all_assignments_f.person_id%type;
2139: p_assignment_id_t per_all_assignments_f.assignment_id%type;

Line 2156: p_final_process_date_t per_periods_of_service.final_process_date%type;

2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2153: p_frequency_t per_all_assignments_f.frequency%type;
2154: p_grade_id_t per_all_assignments_f.grade_id%type;
2155: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2156: p_final_process_date_t per_periods_of_service.final_process_date%type;
2157: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;
2158:
2159: cursor csr_fet_assignment(p_ass_id number,p_effst_date date)
2160: is

Line 2157: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;

2153: p_frequency_t per_all_assignments_f.frequency%type;
2154: p_grade_id_t per_all_assignments_f.grade_id%type;
2155: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2156: p_final_process_date_t per_periods_of_service.final_process_date%type;
2157: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;
2158:
2159: cursor csr_fet_assignment(p_ass_id number,p_effst_date date)
2160: is
2161: SELECT pas.person_id,

Line 2190: per_periods_of_service pos,

2186: 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
2187:
2188: FROM per_all_people_f ppf,
2189: per_all_assignments_f pas,
2190: per_periods_of_service pos,
2191: per_periods_of_placement pop
2192: WHERE pas.assignment_id = p_ass_id
2193: AND pas.person_id = ppf.person_id
2194: AND pas.person_id = pop.person_id (+)