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 936: from per_periods_of_service

932: l_transaction_id_canonical Varchar2(30);
933:
934: cursor csr_person_id(p_prd_service_id varchar2,p_date date) is
935: select distinct person_id
936: from per_periods_of_service
937: where period_of_service_id = p_prd_service_id
938: and p_date between date_start and nvl(actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'));
939:
940: /*code added for 8424994*/

Line 1648: per_periods_of_service pos,

1644:
1645: primary_flag as "PRIMARY_FLAG"
1646:
1647: FROM per_all_assignments_f pas,
1648: per_periods_of_service pos,
1649: per_periods_of_placement pop
1650: WHERE pas.person_id = pop.person_id (+)
1651: AND pas.person_id = pos.person_id (+)
1652: AND pas.assignment_id = :1

Line 2317: p_final_process_date per_periods_of_service.final_process_date%type;

2313: p_normal_hours per_all_assignments_f.normal_hours%type;
2314: p_frequency per_all_assignments_f.frequency%type;
2315: p_grade_id per_all_assignments_f.grade_id%type;
2316: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2317: p_final_process_date per_periods_of_service.final_process_date%type;
2318: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2319: p_primary_flag per_all_assignments_f.primary_flag%type;
2320:
2321: -- data required for message from table

Line 2318: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;

2314: p_frequency per_all_assignments_f.frequency%type;
2315: p_grade_id per_all_assignments_f.grade_id%type;
2316: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2317: p_final_process_date per_periods_of_service.final_process_date%type;
2318: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2319: p_primary_flag per_all_assignments_f.primary_flag%type;
2320:
2321: -- data required for message from table
2322: p_person_id_t per_all_assignments_f.person_id%type;

Line 2340: p_final_process_date_t per_periods_of_service.final_process_date%type;

2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2337: p_frequency_t per_all_assignments_f.frequency%type;
2338: p_grade_id_t per_all_assignments_f.grade_id%type;
2339: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2340: p_final_process_date_t per_periods_of_service.final_process_date%type;
2341: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;
2342: p_primary_flag_t per_all_assignments_f.primary_flag%type;
2343:
2344: l_transaction_id Number;

Line 2341: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;

2337: p_frequency_t per_all_assignments_f.frequency%type;
2338: p_grade_id_t per_all_assignments_f.grade_id%type;
2339: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2340: p_final_process_date_t per_periods_of_service.final_process_date%type;
2341: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;
2342: p_primary_flag_t per_all_assignments_f.primary_flag%type;
2343:
2344: l_transaction_id Number;
2345: l_transaction_id_canonical Varchar2(30);

Line 2380: per_periods_of_service pos,

2376: primary_flag
2377:
2378: FROM per_all_people_f ppf,
2379: per_all_assignments_f pas,
2380: per_periods_of_service pos,
2381: per_periods_of_placement pop
2382: WHERE pas.assignment_id = p_ass_id
2383: AND pas.person_id = ppf.person_id
2384: AND pas.person_id = pop.person_id (+)