DBA Data[Home] [Help]

APPS.PSP_ERD_BUS dependencies on PSP_EFF_REPORTS

Line 37: , psp_eff_reports per

33: select pbg.security_group_id,
34: pbg.legislation_code
35: from per_business_groups_perf pbg
36: , psp_eff_report_details erd
37: , psp_eff_reports per
38: where erd.effort_report_detail_id = p_effort_report_detail_id
39: and erd.effort_report_id = per.effort_report_id
40: and pbg.business_group_id = per.business_group_id ;
41:

Line 115: , psp_eff_reports per

111: cursor csr_leg_code is
112: select pbg.legislation_code
113: from per_business_groups_perf pbg
114: , psp_eff_report_details erd
115: , psp_eff_reports per
116: where erd.effort_report_detail_id = p_effort_report_detail_id
117: and erd.effort_report_id = per.effort_report_id
118: and pbg.business_group_id = per.business_group_id ;
119: --