APPS.PSP_PSC_BUS dependencies on PSP_SALARY_CAPS

Line 32: -- psp_salary_caps and PER_BUSINESS_GROUPS_PERF

28: --
29: -- salary caps are global. BG check is not required
30:
31: -- EDIT_HERE In the following cursor statement add join(s) between
32: -- psp_salary_caps and PER_BUSINESS_GROUPS_PERF
33: -- so that the security_group_id for
34: -- the current business group context can be derived.
35: -- Remove this comment when the edit has been completed.
36: cursor csr_sec_grp is

Line 39: from psp_salary_caps psc

35: -- Remove this comment when the edit has been completed.
36: cursor csr_sec_grp is
37: select pbg.security_group_id,
38: pbg.legislation_code
39: from psp_salary_caps psc
40: -- , per_business_groups_perf pbg
41: -- , EDIT_HERE table_name(s) 333
42: where psc.salary_cap_id = p_salary_cap_id;
43: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 112: -- psp_salary_caps and PER_BUSINESS_GROUPS_PERF

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

Line 119: , psp_salary_caps psc

115: -- Remove this comment when the edit has been completed.
116: cursor csr_leg_code is
117: select pbg.legislation_code
118: from per_business_groups_perf pbg
119: , psp_salary_caps psc
120: -- , EDIT_HERE table_name(s) 333
121: where psc.salary_cap_id = p_salary_cap_id;
122: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
123: --

Line 255: FROM psp_salary_caps

251: --Cursor date_selection_csr: Select the dates for the accounts(other than the current one) of this organization.
252:
253: CURSOR date_selection_csr IS
254: SELECT start_date, end_date
255: FROM psp_salary_caps
256: WHERE funding_source_code = p_funding_source_code
257: AND currency_code = p_currency_code
258: AND salary_cap_id <> NVL(p_salary_cap_id,-999);
259: