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_ERA_BUS dependencies on PSP_EFF_REPORT_DETAILS

Line 37: , psp_eff_report_details erd

33: select pbg.security_group_id,
34: pbg.legislation_code
35: from per_business_groups_perf pbg
36: , psp_eff_report_approvals era
37: , psp_eff_report_details erd
38: , psp_eff_reports per
39: where era.effort_report_approval_id = p_effort_report_approval_id
40: and era.effort_report_detail_id = erd.effort_report_detail_id
41: and erd.effort_report_id = per.effort_report_id

Line 116: , psp_eff_report_details erd

112: cursor csr_leg_code is
113: select pbg.legislation_code
114: from per_business_groups_perf pbg
115: , psp_eff_report_approvals era
116: , psp_eff_report_details erd
117: , psp_eff_reports per
118: where era.effort_report_approval_id = p_effort_report_approval_id
119: and era.effort_report_detail_id = erd.effort_report_detail_id
120: and erd.effort_report_id = per.effort_report_id