APPS.PSP_ERA_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 28: -- psp_eff_report_approvals 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_approvals 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 35: from per_business_groups_perf pbg

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

Line 108: -- psp_eff_report_approvals and PER_BUSINESS_GROUPS_PERF

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

Line 114: from per_business_groups_perf pbg

110: -- the current business group context can be derived.
111: -- Remove this comment when the edit has been completed.
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