APPS.PAY_SPR_BUS dependencies on PAY_ALL_PAYROLLS_F

Line 178: (p_payroll_id in pay_all_payrolls_f.payroll_id%type

174: -- --------------------------------------------------------------------------
175: -- |---------------------------< chk_payroll_id >---------------------------|
176: -- --------------------------------------------------------------------------
177: Procedure chk_payroll_id
178: (p_payroll_id in pay_all_payrolls_f.payroll_id%type
179: ,p_security_profile_id in pay_security_payrolls.security_profile_id%type
180: ,p_business_group_id out nocopy pay_all_payrolls_f.business_group_id%type)
181: --
182: is

Line 180: ,p_business_group_id out nocopy pay_all_payrolls_f.business_group_id%type)

176: -- --------------------------------------------------------------------------
177: Procedure chk_payroll_id
178: (p_payroll_id in pay_all_payrolls_f.payroll_id%type
179: ,p_security_profile_id in pay_security_payrolls.security_profile_id%type
180: ,p_business_group_id out nocopy pay_all_payrolls_f.business_group_id%type)
181: --
182: is
183: --
184: l_proc varchar2(80) := g_package||'chk_payroll_id';

Line 194: Select distinct pay_all_payrolls_f.business_group_id

190: hr_utility.set_location(to_char(p_security_profile_id),15);
191:
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

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 197: Where pay_all_payrolls_f.business_group_id =

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;
201:

Line 199: And pay_all_payrolls_f.payroll_id = p_payroll_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
203: When no_data_found then