APPS.PAY_SPR_DEL dependencies on PAY_SECURITY_PAYROLLS

Line 62: -- Delete the pay_security_payrolls row.

58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: pay_spr_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pay_security_payrolls row.
63: --
64: delete from pay_security_payrolls
65: where security_profile_id = p_rec.security_profile_id
66: and payroll_id = p_rec.payroll_id;

Line 64: delete from pay_security_payrolls

60: pay_spr_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pay_security_payrolls row.
63: --
64: delete from pay_security_payrolls
65: where security_profile_id = p_rec.security_profile_id
66: and payroll_id = p_rec.payroll_id;
67: --
68: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

Line 198: (p_module_name => 'PAY_SECURITY_PAYROLLS'

194: --
195: when hr_api.cannot_find_prog_unit then
196: --
197: hr_api.cannot_find_prog_unit_error
198: (p_module_name => 'PAY_SECURITY_PAYROLLS'
199: ,p_hook_type => 'AD');
200: --
201: end;
202: --