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.PATC dependencies on PER_PERIODS_OF_SERVICE

Line 203: l_ac_termination_date per_periods_of_service.actual_termination_date%type; /Basebug#4604614 (BaseBug#4118885) /

199: l_CURRENT_EMPLOYEE_FLAG varchar2(1);
200: l_CURRENT_NPW_FLAG VARCHAR2(1);
201: l_person_type VARCHAR2(10);
202: l_job_id NUMBER ; -- Added for bug 4044057
203: l_ac_termination_date per_periods_of_service.actual_termination_date%type; /*Basebug#4604614 (BaseBug#4118885) */
204: -- bug 10271889 start
205: l_final_process_date per_periods_of_service.final_process_date%TYPE;
206:
207: l_task_count NUMBER := 0; -- Added as part of Bug 16220146

Line 205: l_final_process_date per_periods_of_service.final_process_date%TYPE;

201: l_person_type VARCHAR2(10);
202: l_job_id NUMBER ; -- Added for bug 4044057
203: l_ac_termination_date per_periods_of_service.actual_termination_date%type; /*Basebug#4604614 (BaseBug#4118885) */
204: -- bug 10271889 start
205: l_final_process_date per_periods_of_service.final_process_date%TYPE;
206:
207: l_task_count NUMBER := 0; -- Added as part of Bug 16220146
208: l_task_id NUMBER; -- Added as part of Bug 16220146
209:

Line 212: FROM per_periods_of_service

208: l_task_id NUMBER; -- Added as part of Bug 16220146
209:
210: CURSOR cur_final_process_date (X_person_id NUMBER, X_date DATE) IS
211: SELECT MAX(nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')))
212: FROM per_periods_of_service
213: WHERE person_id = X_person_id
214: AND nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')) > = trunc(X_date);
215:
216: -- bug 10271889 end

Line 1289: from per_all_people_f p, per_periods_of_service pos

1285: /*Commeneted the changes for bug#13709322 */
1286:
1287: /*12737060 select distinct p.CURRENT_EMPLOYEE_FLAG , p.CURRENT_NPW_FLAG
1288: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1289: from per_all_people_f p, per_periods_of_service pos
1290: where p.person_id = x_person_id
1291: and p.person_id = pos.person_id
1292: and p.effective_start_date = pos.date_start
1293: and x_ei_date between pos.date_start and

Line 1306: from per_all_people_f p, per_periods_of_service pos

1302: --{
1303: select distinct p.CURRENT_EMPLOYEE_FLAG ,
1304: p.CURRENT_NPW_FLAG
1305: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1306: from per_all_people_f p, per_periods_of_service pos
1307: where p.person_id = x_person_id
1308: and p.person_id = pos.person_id
1309: and p.effective_start_date = pos.date_start
1310: and x_ei_date between pos.date_start and

Line 1338: from per_all_people_f p, per_periods_of_service pos

1334: --{
1335:
1336: select distinct p.CURRENT_EMPLOYEE_FLAG , p.CURRENT_NPW_FLAG
1337: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1338: from per_all_people_f p, per_periods_of_service pos
1339: where p.person_id = x_person_id
1340: and p.person_id = pos.person_id
1341: and p.effective_start_date = pos.date_start
1342: and x_ei_date between pos.date_start and

Line 2325: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type) IS

2321: /* Added procedure check_termination for Bug#4604614 (BaseBug#4118885) */
2322:
2323: procedure check_termination (p_person_id in per_all_people_f.person_id%type,
2324: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
2325: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type) IS
2326:
2327: cursor check_periods_of_service is
2328: select null
2329: from per_periods_of_service

Line 2329: from per_periods_of_service

2325: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type) IS
2326:
2327: cursor check_periods_of_service is
2328: select null
2329: from per_periods_of_service
2330: where person_id = p_person_id
2331: and p_ei_date between date_start and nvl(actual_termination_date, p_ei_date);
2332:
2333: l_actual_termination_date per_periods_of_service.actual_termination_date%type := NULL;

Line 2333: l_actual_termination_date per_periods_of_service.actual_termination_date%type := NULL;

2329: from per_periods_of_service
2330: where person_id = p_person_id
2331: and p_ei_date between date_start and nvl(actual_termination_date, p_ei_date);
2332:
2333: l_actual_termination_date per_periods_of_service.actual_termination_date%type := NULL;
2334: begin
2335:
2336: open check_periods_of_service;
2337:

Line 2343: from per_periods_of_service

2339: if check_periods_of_service%notfound then
2340: begin
2341: select actual_termination_date into l_actual_termination_date from (
2342: select actual_termination_date
2343: from per_periods_of_service
2344: where person_id = p_person_id
2345: and actual_termination_date < p_ei_date
2346: order by actual_termination_date desc)
2347: where rownum = 1;