DBA Data[Home] [Help]

APPS.PAY_AU_EXC dependencies on FND_DATE

Line 369: SELECT fnd_date.canonical_to_date(org_information11)

365: l_beg_of_fiscal_year date;
366: l_user_le_start_date date;
367: cursor get_beg_of_fiscal_year(c_owner_payroll_action_id number)
368: is
369: SELECT fnd_date.canonical_to_date(org_information11)
370: FROM pay_payroll_actions PACT,
371: hr_organization_information HOI
372: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
373: AND HOI.organization_id = PACT.business_group_id

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

385: hr_utility.trace('p_dimension_name :' ||p_dimension_name );
386:
387: /*6159013 These Two Dimension Never Expires hence Returning 31-DEC-4712 as expiry Date*/
388: IF p_dimension_name in ('_ASG_TD','_ASG_LE_TD') THEN
389: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');
390:
391: /* These balance dimensions never expire and hence considered as special cases
392: return the p_owner_effective_date for these cases */
393: ELSIF p_dimension_name in ('_ASG_RUN','_ASG_LE_RUN') THEN --2610141