241: --------------------------------------------------------------------------------
242: is
243: l_fiscal_year_start_date date;
244: cursor csr_fiscal_year_start_date is
245: select fnd_date.canonical_to_date(hoi.org_information11)
246: from hr_organization_information hoi,
247: pay_payroll_actions ppa
248: where ppa.payroll_action_id = p_payroll_action_id
249: and hoi.organization_id = ppa.business_group_id
259: end if;
260: close csr_fiscal_year_start_date;
261: --
262: g_fiscal_year.payroll_action_id := p_payroll_action_id;
263: g_fiscal_year.fiscal_year_start_date := nvl(l_fiscal_year_start_date, fnd_date.canonical_to_date('2000/01/01'));
264: end if;
265: --
266: return g_fiscal_year.fiscal_year_start_date;
267: end fiscal_year_start_date;
341: p_expiry_information out NOCOPY date) -- dimension expired date.
342: --------------------------------------------------------------------------------
343: is
344: begin
345: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');
346: end itd_ec;
347:
348: --------------------------------------------------------------------------------
349: procedure fytd_ec(
764: l_bonus_period_start_date date;
765: --
766: cursor csr_ovrd_ass_start_date(p_assignment_action_id number) is
767: select
768: fnd_date.canonical_to_date(prrv.result_value)
769: from pay_run_result_values prrv,
770: pay_run_results prr,
771: pay_payroll_actions ppa,
772: pay_assignment_actions paa,
837: --
838: if g_bonus_payroll_action_id = p_payroll_action_id then
839: null;
840: else
841: g_bonus_pay_period_start_date := fnd_date.canonical_to_date(
842: pay_kr_ff_functions_pkg.get_legislative_parameter(
843: p_payroll_action_id,
844: 'BONUS_PERIOD_START_DATE',
845: null));