APPS.PAY_SPR_BUS dependencies on PER_SECURITY_PROFILES

Line 196: From per_security_profiles, pay_all_payrolls_f

192: --Ensure that the payroll_id and security_profile_id are valid
193:
194: Select distinct pay_all_payrolls_f.business_group_id
195: Into p_business_group_id
196: From per_security_profiles, pay_all_payrolls_f
197: Where pay_all_payrolls_f.business_group_id =
198: per_security_profiles.business_group_id
199: And pay_all_payrolls_f.payroll_id = p_payroll_id
200: And per_security_profiles.security_profile_id = p_security_profile_id;

Line 198: per_security_profiles.business_group_id

194: Select distinct pay_all_payrolls_f.business_group_id
195: Into p_business_group_id
196: From per_security_profiles, pay_all_payrolls_f
197: Where pay_all_payrolls_f.business_group_id =
198: per_security_profiles.business_group_id
199: And pay_all_payrolls_f.payroll_id = p_payroll_id
200: And per_security_profiles.security_profile_id = p_security_profile_id;
201:
202: Exception

Line 200: And per_security_profiles.security_profile_id = p_security_profile_id;

196: From per_security_profiles, pay_all_payrolls_f
197: Where pay_all_payrolls_f.business_group_id =
198: per_security_profiles.business_group_id
199: And pay_all_payrolls_f.payroll_id = p_payroll_id
200: And per_security_profiles.security_profile_id = p_security_profile_id;
201:
202: Exception
203: When no_data_found then
204: fnd_message.set_name('PER', 'HR_289801_INVALID_PAYROLL_ID');

Line 213: (p_security_profile_id in per_security_profiles.security_profile_id%type

209: -- --------------------------------------------------------------------------
210: -- |--------------------------------------------------|
211: -- --------------------------------------------------------------------------
212: Procedure chk_security_profile
213: (p_security_profile_id in per_security_profiles.security_profile_id%type
214: ,p_business_group_id out nocopy per_security_profiles.business_group_id%type)
215: --
216: is
217: --

Line 214: ,p_business_group_id out nocopy per_security_profiles.business_group_id%type)

210: -- |--------------------------------------------------|
211: -- --------------------------------------------------------------------------
212: Procedure chk_security_profile
213: (p_security_profile_id in per_security_profiles.security_profile_id%type
214: ,p_business_group_id out nocopy per_security_profiles.business_group_id%type)
215: --
216: is
217: --
218: e_null_business_group_id Exception;

Line 228: From per_security_profiles

224: --Ensure that the security profile id is not global
225:
226: Select business_group_id
227: Into p_business_group_id
228: From per_security_profiles
229: Where security_profile_id = p_security_profile_id;
230: hr_utility.set_location(to_char(p_business_group_id),15);
231: If p_business_group_id is null then
232: hr_utility.set_location(to_char(p_business_group_id),16);

Line 333: l_view_all_payrolls_flag per_security_profiles.view_all_payrolls_flag%TYPE;

329: (p_security_profile_id IN NUMBER)
330: IS
331:
332: l_proc VARCHAR2(80) := g_package||'chk_view_all_payrolls_flag';
333: l_view_all_payrolls_flag per_security_profiles.view_all_payrolls_flag%TYPE;
334:
335: --
336: -- Fetches the view_all_payrolls_flag.
337: --

Line 340: FROM per_security_profiles psp

336: -- Fetches the view_all_payrolls_flag.
337: --
338: CURSOR csr_get_view_all_payrolls IS
339: SELECT psp.view_all_payrolls_flag
340: FROM per_security_profiles psp
341: WHERE psp.security_profile_id = p_security_profile_id;
342:
343: BEGIN
344:

Line 429: UPDATE per_security_profiles

425: -- Update the view all payrolls flag on the Security Profile.
426: --
427: hr_utility.set_location(l_proc, 30);
428:
429: UPDATE per_security_profiles
430: SET view_all_payrolls_flag = 'Y'
431: WHERE security_profile_id = p_security_profile_id;
432:
433: END IF;