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.

[Home] [Help]

APPS.PSP_ER_WORKFLOW dependencies on PSP_EFF_REPORT_DETAILS

Line 222: psp_eff_report_details erd

218: psp_wf_item_key_s.nextval
219: from (select era.wf_role_name
220: from psp_eff_report_approvals era,
221: psp_eff_reports er,
222: psp_eff_report_details erd
223: where erd.effort_report_id = er.effort_report_id
224: and erd.effort_report_detail_id = era.effort_report_detail_id
225: and era.approval_status = 'P'
226: and era.approver_order_num = 1

Line 305: psp_eff_report_details erd

301: where wf_role_name = wf_rname_array(k)
302: and effort_report_detail_id in
303: (select erd.effort_report_detail_id
304: from psp_eff_reports er,
305: psp_eff_report_details erd
306: where erd.effort_report_id = er.effort_report_id
307: and er.request_id = l_request_id
308: and er.status_code = 'N');
309: k := 1;

Line 458: from psp_eff_report_details

454: aname => 'REQUEST_ID');
455: delete psp_eff_report_approvals
456: where effort_report_detail_id in
457: (select effort_report_detail_id
458: from psp_eff_report_details
459: where effort_report_id in
460: (select effort_report_id
461: from psp_eff_reports
462: where request_id = l_request_id));

Line 464: delete psp_eff_report_details

460: (select effort_report_id
461: from psp_eff_reports
462: where request_id = l_request_id));
463:
464: delete psp_eff_report_details
465: where effort_report_id in
466: (select effort_report_id
467: from psp_eff_reports
468: where request_id = l_request_id);

Line 491: FROM psp_eff_report_details perd

487: fnd_documents_vl fdl
488: WHERE fad.pk1_value IN (SELECT wf_item_key
489: FROM psp_eff_report_approvals pera
490: WHERE pera.effort_report_detail_id IN (SELECT perd.effort_report_detail_id
491: FROM psp_eff_report_details perd
492: WHERE perd.effort_report_id IN (SELECT per.effort_report_id
493: FROM psp_eff_reports per
494: WHERE per.request_id = l_request_id)))
495: AND fdl.document_id = fad.document_id

Line 577: from psp_eff_report_details erd

573: and approver_order_num = 1;
574:
575: cursor ame_txn_id_cur is
576: select distinct erd.ame_transaction_id
577: from psp_eff_report_details erd
578: where erd.effort_report_detail_id in
579: (select era.effort_report_detail_id
580: from psp_eff_report_approvals era
581: where wf_item_key = itemkey

Line 674: from psp_eff_report_details erd,

670: er.last_updated_by = fnd_global.user_id
671: where er.status_code = 'N'
672: and er.effort_report_id in
673: (select erd.effort_report_id
674: from psp_eff_report_details erd,
675: psp_eff_report_approvals era
676: where era.effort_report_detail_id = erd.effort_report_detail_id
677: and era.wf_item_key = itemkey)
678: and not exists

Line 681: psp_eff_report_details erd

677: and era.wf_item_key = itemkey)
678: and not exists
679: (select 1
680: from psp_eff_report_approvals era,
681: psp_eff_report_details erd
682: where era.effort_report_detail_id = erd.effort_report_detail_id
683: and erd.effort_report_id = er.effort_report_id
684: and era.approval_status <> 'A');
685: result := 'COMPLETE:NOTFOUND';

Line 753: from psp_eff_report_details erd

749: sysdate,
750: l_user_id,
751: l_next_approver(1).display_name,
752: 1
753: from psp_eff_report_details erd
754: where erd.ame_transaction_id = ame_txn_id_array(i)
755: and erd.effort_report_id in
756: (select er.effort_report_id
757: from psp_eff_reports er

Line 792: psp_eff_report_details erd

788: where A1.approver_order_num = l_approver_order_num and
789: A1.effort_report_detail_id in
790: (select erd.effort_report_detail_id
791: from psp_eff_reports er,
792: psp_eff_report_details erd
793: where er.request_id = l_request_id
794: and er.effort_report_id = erd.effort_report_id
795: and erd.ame_transaction_id = ame_txn_id_array(i)
796: and er.status_code = 'N');

Line 813: from psp_eff_report_details erd,

809: er.last_updated_by = fnd_global.user_id
810: where er.status_code = 'N'
811: and er.effort_report_id in
812: (select erd.effort_report_id
813: from psp_eff_report_details erd,
814: psp_eff_report_approvals era
815: where era.effort_report_detail_id = erd.effort_report_detail_id
816: and era.wf_item_key = itemkey)
817: and not exists

Line 820: psp_eff_report_details erd

816: and era.wf_item_key = itemkey)
817: and not exists
818: (select 1
819: from psp_eff_report_approvals era,
820: psp_eff_report_details erd
821: where era.effort_report_detail_id = erd.effort_report_detail_id
822: and erd.effort_report_id = er.effort_report_id
823: and era.approval_status <> 'A');
824: end if;

Line 922: from psp_eff_report_details

918: select effort_report_id
919: from psp_eff_reports
920: where effort_report_id in
921: (select effort_report_id
922: from psp_eff_report_details
923: where effort_report_detail_id in
924: (select effort_report_detail_id
925: from psp_eff_report_approvals
926: where wf_item_key = itemkey

Line 934: psp_eff_report_details erd,

930: --- partial approval by 2 approvers.
931: cursor past_approvers_cur is
932: select distinct era.wf_role_name
933: from psp_eff_reports er,
934: psp_eff_report_details erd,
935: psp_eff_report_approvals era,
936: fnd_user fu -- Bug 6641216
937: where era.effort_report_detail_id = erd.effort_report_detail_id
938: and erd.effort_report_id = er.effort_report_id

Line 946: from psp_eff_report_details

942: (select effort_report_id
943: from psp_eff_reports
944: where effort_report_id in
945: (select effort_report_id
946: from psp_eff_report_details
947: where effort_report_detail_id in
948: (select effort_report_detail_id
949: from psp_eff_report_approvals
950: where wf_item_key = itemkey

Line 965: from psp_eff_report_details erd,

961: where request_id = l_request_id);
962:
963: cursor get_txn_id_cur is
964: select distinct ame_transaction_id
965: from psp_eff_report_details erd,
966: psp_eff_report_approvals era
967: where erd.effort_report_detail_id = era.effort_report_detail_id
968: and era.wf_item_key = itemkey
969: and era.approval_status = 'P'

Line 1044: from psp_eff_report_details erd,

1040: where era.wf_item_key = itemkey
1041: and era.wf_role_name = l_rname
1042: and exists
1043: ( select erd.effort_report_detail_id
1044: from psp_eff_report_details erd,
1045: psp_eff_reports er
1046: where er.effort_report_id = erd.effort_report_id
1047: and erd.effort_report_detail_id = era.effort_report_detail_id
1048: and er.status_code = 'S' );

Line 1061: from psp_eff_report_details erd,

1057: where era.wf_item_key = itemkey
1058: and era.wf_role_name = l_rname
1059: and not exists
1060: ( select erd.effort_report_detail_id
1061: from psp_eff_report_details erd,
1062: psp_eff_reports er
1063: where er.effort_report_id = erd.effort_report_id
1064: and erd.effort_report_detail_id = era.effort_report_detail_id
1065: and er.status_code = 'S' );

Line 1158: from psp_eff_report_details erd,

1154: and wf_role_name = l_rname;
1155:
1156: cursor get_txn_id_cur is
1157: select distinct ame_transaction_id
1158: from psp_eff_report_details erd,
1159: psp_eff_report_approvals era
1160: where erd.effort_report_detail_id = era.effort_report_detail_id
1161: and era.wf_item_key = itemkey
1162: and era.approval_status = 'A'

Line 1212: from psp_eff_report_details erd,

1208: and era.wf_orig_system = l_orig_system
1209: and era.approval_status = 'P'
1210: and exists
1211: ( select erd.effort_report_detail_id
1212: from psp_eff_report_details erd,
1213: psp_eff_reports er
1214: where er.effort_report_id = erd.effort_report_id
1215: and erd.effort_report_detail_id = era.effort_report_detail_id
1216: and er.status_code = 'S' );

Line 1232: from psp_eff_report_details erd,

1228: and era.wf_orig_system = l_orig_system
1229: and era.approval_status = 'P'
1230: and not exists
1231: ( select erd.effort_report_detail_id
1232: from psp_eff_report_details erd,
1233: psp_eff_reports er
1234: where er.effort_report_id = erd.effort_report_id
1235: and erd.effort_report_detail_id = era.effort_report_detail_id
1236: and er.status_code = 'S' );

Line 1303: from psp_eff_report_details erd,

1299: and wf_role_name = l_rname;
1300:
1301: cursor get_txn_id_cur is
1302: select distinct ame_transaction_id
1303: from psp_eff_report_details erd,
1304: psp_eff_report_approvals era
1305: where erd.effort_report_detail_id = era.effort_report_detail_id
1306: and era.wf_item_key = itemkey
1307: and era.approval_status = 'P'

Line 1346: psp_eff_report_details perd,

1342: SELECT distinct prth.hundred_pcent_eff_at_per_asg, per.start_date,
1343: per.end_date, per.person_id, perd.assignment_id, per.full_name, perd.assignment_number
1344: FROM psp_report_templates_h prth,
1345: psp_eff_reports per,
1346: psp_eff_report_details perd,
1347: psp_eff_report_approvals prea
1348: WHERE prth.request_id = per.request_id
1349: AND per.effort_report_id = perd.effort_report_id
1350: AND perd.effort_report_detail_id = prea.effort_report_detail_id

Line 1359: psp_eff_report_details perd,

1355:
1356: CURSOR is_person_last_approver_csr IS
1357: SELECT 1
1358: FROM psp_eff_reports per,
1359: psp_eff_report_details perd,
1360: psp_eff_report_approvals prea
1361: WHERE per.effort_report_id = perd.effort_report_id
1362: AND perd.effort_report_detail_id = prea.effort_report_detail_id
1363: AND per.person_id = l_person_id

Line 1374: psp_eff_report_details perd,

1370:
1371: CURSOR is_asg_last_approver_csr IS
1372: SELECT 1
1373: FROM psp_eff_reports per,
1374: psp_eff_report_details perd,
1375: psp_eff_report_approvals prea
1376: WHERE per.effort_report_id = perd.effort_report_id
1377: AND perd.effort_report_detail_id = prea.effort_report_detail_id
1378: AND perd.assignment_id = l_assignment_id

Line 1390: psp_eff_report_details perd,

1386:
1387: CURSOR person_percent_csr IS
1388: SELECT sum(nvl(overwritten_effort_percent,payroll_percent)),sum(actual_salary_amt) -- 14653352 : Added sum(actual_salary_amt)
1389: FROM psp_eff_reports per,
1390: psp_eff_report_details perd,
1391: psp_eff_report_approvals prea
1392: WHERE per.effort_report_id = perd.effort_report_id
1393: AND perd.effort_report_detail_id = prea.effort_report_detail_id
1394: AND per.person_id = l_person_id

Line 1404: psp_eff_report_details perd,

1400:
1401: CURSOR assignment_percent_csr IS
1402: SELECT sum(nvl(overwritten_effort_percent,payroll_percent)),sum(actual_salary_amt) -- 14653352 : Added sum(actual_salary_amt)
1403: FROM psp_eff_reports per,
1404: psp_eff_report_details perd,
1405: psp_eff_report_approvals prea
1406: WHERE per.effort_report_id = perd.effort_report_id
1407: AND perd.effort_report_detail_id = prea.effort_report_detail_id
1408: AND perd.assignment_id = l_assignment_id

Line 1631: from psp_eff_report_details

1627: select person_id
1628: from psp_eff_reports
1629: where effort_report_id in
1630: (select effort_report_id
1631: from psp_eff_report_details
1632: where request_id = l_request_id
1633: and effort_report_detail_id in
1634: (select effort_report_detail_id
1635: from psp_eff_report_approvals