APPS.PAY_NZ_EXC dependencies on FND_DATE

Line 292: select fnd_date.canonical_to_date(org_information11)

288: l_beg_of_fiscal_year date;
289: l_dimension_name pay_balance_dimensions.dimension_name%type ;
290:
291: cursor get_beg_of_fiscal_year(c_owner_payroll_action_id number) is
292: select fnd_date.canonical_to_date(org_information11)
293: from pay_payroll_actions PACT,
294: hr_organization_information HOI
295: where UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
296: and HOI.organization_id = PACT.business_group_id

Line 302: p_expiry_information := fnd_date.canonical_to_date('4712/12/31'); --Added check for bug 6263808

298: begin
299: l_dimension_name := upper(p_dimension_name);
300:
301: IF l_dimension_name = '_ASG_TD' THEN --Added check for bug 6263808
302: p_expiry_information := fnd_date.canonical_to_date('4712/12/31'); --Added check for bug 6263808
303: elsif l_dimension_name = '_ASG_YTD' then
304: p_expiry_information := next_fin_year(to_date(g_nz_fin_year_start,'DD-MM-'), p_owner_effective_date)-1;
305: elsif l_dimension_name = '_ASG_FY_QTD' then
306: open get_beg_of_fiscal_year(p_owner_payroll_action_id);