APPS.PAY_JP_YEA_BAL_ADJ_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

		select fnd_number.canonical_to_number(org_information5)
		from hr_organization_information
		where organization_id = fnd_number.canonical_to_number(p_business_group_id)
		and org_information_context = 'JP_BUSINESS_GROUP_INFO';

Line: 31

		select fnd_number.canonical_to_number(prl_information4)
		from pay_all_payrolls_f
		where payroll_id = fnd_number.canonical_to_number(p_payroll_id)
		and fnd_date.canonical_to_date(p_effective_date)
			between effective_start_date and effective_end_date;

Line: 38

		select fft.formula_name
		from ff_formulas_f ff, ff_formulas_f_tl fft
		where ff.formula_id = nvl(l_pay_formula_id, l_org_formula_id)
		and fnd_date.canonical_to_date(p_effective_date)
			between ff.effective_start_date and ff.effective_end_date
		and fft.formula_id = ff.formula_id
		and fft.language = userenv('LANG');

Line: 91

	select to_number(pay_core_utils.get_parameter('FORMULA_ID', legislative_parameters))
	into l_formula_id
	from pay_payroll_actions
	where payroll_action_id = p_payroll_action_id;