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.PSP_CREATE_EFF_REPORTS dependencies on PSP_SELECTED_PERSONS_T

Line 17: SELECT person_id from psp_selected_persons_t where

13: l_asgactid number;
14:
15:
16: CURSOR c_person_actions(p_pactid number, stperson NUMBER, endperson NUMBER) is
17: SELECT person_id from psp_selected_persons_t where
18: person_id between stperson and endperson and request_id in
19: (select request_id from pay_payroll_actions where payroll_action_id= p_pactid);
20:
21: begin

Line 203: select distinct person_id from psp_selected_persons_t where request_id = p_request_id and person_id between

199:
200: */
201:
202: cursor get_all_person(p_request_id in number) is
203: select distinct person_id from psp_selected_persons_t where request_id = p_request_id and person_id between
204: l_start_person and l_end_person;
205:
206: -- for supercede
207: cursor get_supercede_persons is

Line 386: psp_Selected_persons_t pspt,

382: null distribution_date1, null distribution_date2
383: FROM
384: psp_distribution_lines_history pdnh,
385: psp_summary_lines psl,
386: psp_Selected_persons_t pspt,
387: psp_pre_gen_dist_lines_history ppg,
388: psp_adjustment_lineS_history pal,
389: psp_payroll_sub_lines ppsl,
390: psp_payroll_lines ppl

Line 451: psp_Selected_persons_t pspt

447: Null SEGMENT21, null SEGMENT22, null SEGMENT23, null SEGMENT24, null SEGMENT25,
448: null SEGMENT26, null SEGMENT27, null SEGMENT28, null SEGMENT29, null SEGMENT30,
449: psl.distribution_amount distribution_amount, null , null
450: FROM psp_external_effort_lines psl,
451: psp_Selected_persons_t pspt
452: WHERE psl.person_id = pspt.person_id
453: and pspt.request_id = :l_request_id
454: AND pspt.person_id between :l_start_person and :l_end_person
455: /*

Line 486: insert into psp_selected_persons_t (request_id, person_id)

482:
483: --Bug 5237611: Fixed terminated assignment Issue, added FF suport for assignment
484: /*
485: if l_selection_match_level = 'EMP' then
486: insert into psp_selected_persons_t (request_id, person_id)
487: select -1 * l_request_id, gt.person_id from psp_supercede_persons_gt gt
488: where gt.person_id > 0 ;
489: else
490: */

Line 491: insert into psp_selected_persons_t (request_id, person_id, assignment_id)

487: select -1 * l_request_id, gt.person_id from psp_supercede_persons_gt gt
488: where gt.person_id > 0 ;
489: else
490: */
491: insert into psp_selected_persons_t (request_id, person_id, assignment_id)
492: select -1 * l_request_id, person_id, assignment_id
493: from psp_Eff_reports er,
494: psp_eff_report_details erd
495: where er.effort_Report_id = erd.effort_Report_id

Line 1277: from psp_selected_persons_t pspt,

1273: l_return_status varchar2(1);
1274:
1275: cursor get_skipped_asg is
1276: select distinct pspt.skip_reason, pspt.person_id, paf.assignment_number
1277: from psp_selected_persons_t pspt,
1278: per_all_assignments_f paf
1279: where pspt.request_id = p_request_id
1280: and pspt.person_id between p_start_person and p_end_person
1281: and pspt.assignment_id = paf.assignment_id

Line 1337: update psp_selected_persons_t

1333: if p_match_level = 'EMP' then
1334: fnd_message.set_name('PSP', 'PSP_EFF_ALREADY_EXISTS');
1335: l_msg_str:= substr(fnd_message.get ,1,240);
1336:
1337: update psp_selected_persons_t
1338: set skip_reason = 'ALREADY_EXISTS'
1339: where person_id between p_start_person and p_end_person
1340: and request_id = p_request_id
1341: and person_id in

Line 1354: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and

1350: source_id, error_message, retry_request_id, pdf_request_id,
1351: source_name, parent_source_id, parent_source_name)
1352: (select psp_report_errors_s.nextval , p_request_id,
1353: 'W', pspt.person_id , l_msg_str , p_retry_request_id, null, NULL, NULL, null
1354: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1355: pspt.request_id = p_request_id and skip_reason is not null
1356: AND rowid = (select min(rowid) from psp_selected_persons_t inner
1357: where inner.request_id = pspt.request_id
1358: AND inner.person_id = pspt.person_id ));

Line 1356: AND rowid = (select min(rowid) from psp_selected_persons_t inner

1352: (select psp_report_errors_s.nextval , p_request_id,
1353: 'W', pspt.person_id , l_msg_str , p_retry_request_id, null, NULL, NULL, null
1354: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1355: pspt.request_id = p_request_id and skip_reason is not null
1356: AND rowid = (select min(rowid) from psp_selected_persons_t inner
1357: where inner.request_id = pspt.request_id
1358: AND inner.person_id = pspt.person_id ));
1359:
1360: else

Line 1362: update psp_selected_persons_t

1358: AND inner.person_id = pspt.person_id ));
1359:
1360: else
1361:
1362: update psp_selected_persons_t
1363: set skip_reason = 'ALREADY_EXISTS'
1364: where person_id between p_start_person and p_end_person
1365: and request_id = p_request_id
1366: and (person_id, assignment_id) in

Line 1375: update psp_selected_persons_t

1371: and g_psp_effort_end >= er.start_date
1372: and g_psp_effort_start <= er.end_date );
1373:
1374: --- existing ER without asg_id summarization.
1375: update psp_selected_persons_t
1376: set skip_reason = 'ALREADY_EXISTS'
1377: where person_id between p_start_person and p_end_person
1378: and request_id = p_request_id
1379: and person_id in

Line 1388: update psp_selected_persons_t

1384: and g_psp_effort_end >= er.start_date
1385: and g_psp_effort_start <= er.end_date
1386: and erd.assignment_id is null);
1387:
1388: update psp_selected_persons_t
1389: set skip_reason = 'OTHER_ASG_SKIPPED'
1390: where person_id between p_start_person and p_end_person
1391: and request_id = p_request_id
1392: and skip_reason is null

Line 1395: from psp_selected_persons_t

1391: and request_id = p_request_id
1392: and skip_reason is null
1393: and person_id in
1394: (select person_id
1395: from psp_selected_persons_t
1396: where person_id between p_start_person and p_end_person
1397: and request_id = p_request_id
1398: and skip_reason = 'ALREADY_EXISTS' );
1399:

Line 1445: from psp_selected_persons_t pspt where pspt.person_id between p_start_person

1441: source_id, error_message, retry_request_id, pdf_request_id,
1442: source_name, parent_source_id, parent_source_name)
1443: select psp_report_errors_s.nextval, p_request_id,'W',
1444: pspt.person_id, l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1445: from psp_selected_persons_t pspt where pspt.person_id between p_start_person
1446: and p_end_person and
1447: pspt.request_id = p_request_id and
1448: pspt.person_id not in (select nvl(person_id,0) from psp_eff_reports where g_psp_effort_end >= start_date and
1449: g_psp_effort_start <= end_date and status_code in ('N', 'A'))

Line 1461: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and

1457: source_id, error_message, retry_request_id, pdf_request_id,
1458: source_name, parent_source_id, parent_source_name)
1459: select psp_report_errors_s.nextval, p_request_id,'W',
1460: pspt.person_id , l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1461: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1462: pspt.request_id = p_request_id and
1463: exists (select nvl(person_id,0) from psp_adjustment_lines where effective_date between g_psp_effort_start
1464: and g_psp_effort_end ) and pspt.person_id not in (select source_id from psp_report_errors where request_id=p_request_id) and
1465: pspt.person_id not in (select nvl(person_id, 0) from psp_eff_reports where g_psp_effort_end>=start_date and