APPS.PSP_ERD_BUS dependencies on PSP_EFF_REPORT_DETAILS

Line 28: -- psp_eff_report_details and PER_BUSINESS_GROUPS_PERF

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- psp_eff_report_details and PER_BUSINESS_GROUPS_PERF
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is

Line 36: , psp_eff_report_details erd

32: cursor csr_sec_grp is
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 ;

Line 107: -- psp_eff_report_details and PER_BUSINESS_GROUPS_PERF

103: --
104: -- Declare cursor
105: --
106: -- EDIT_HERE In the following cursor statement add join(s) between
107: -- psp_eff_report_details and PER_BUSINESS_GROUPS_PERF
108: -- so that the legislation_code for
109: -- the current business group context can be derived.
110: -- Remove this comment when the edit has been completed.
111: cursor csr_leg_code is

Line 114: , psp_eff_report_details erd

110: -- Remove this comment when the edit has been completed.
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 ;