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 449: psp_Selected_persons_t pspt

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

Line 484: insert into psp_selected_persons_t (request_id, person_id)

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

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

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

Line 1275: from psp_selected_persons_t pspt,

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

Line 1335: update psp_selected_persons_t

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

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

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

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

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

Line 1360: update psp_selected_persons_t

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

Line 1373: update psp_selected_persons_t

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

Line 1386: update psp_selected_persons_t

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

Line 1393: from psp_selected_persons_t

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

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

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

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

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