APPS.PAY_NZ_EXC dependencies on FND_DATE

Line 294: select fnd_date.canonical_to_date(org_information11)

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

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

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