APPS.PAY_CN_EXC dependencies on FND_DATE

Line 255: SELECT fnd_date.canonical_to_date(org_information11)

251: l_beg_of_fiscal_year DATE := NULL;
252: l_expiry_date DATE := NULL;
253:
254: CURSOR cur_beg_of_fiscal_year ( p_owner_payroll_action_id NUMBER ) IS
255: SELECT fnd_date.canonical_to_date(org_information11)
256: FROM pay_payroll_actions PACT
257: , hr_organization_information HOI
258: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
259: AND HOI.organization_id = PACT.business_group_id

Line 389: SELECT fnd_date.canonical_to_date(org_information11)

385: l_beg_of_fiscal_year DATE := NULL;
386: l_expiry_date DATE := NULL;
387:
388: CURSOR cur_beg_of_fiscal_year ( p_owner_payroll_action_id NUMBER ) IS
389: SELECT fnd_date.canonical_to_date(org_information11)
390: FROM pay_payroll_actions PACT
391: , hr_organization_information HOI
392: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
393: AND HOI.organization_id = PACT.business_group_id

Line 444: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');

440: ELSIF p_dimension_name LIKE '%YTD' THEN
441: p_expiry_information := next_calendar_year ( p_owner_effective_date) - 1 ;
442:
443: ELSIF p_dimension_name LIKE '%LTD' THEN
444: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');
445:
446: ELSE
447: hr_utility.set_message(801,'NO_EXP_CHECK_FOR_DIMENSION');
448: hr_utility.raise_error;