DBA Data[Home] [Help]

APPS.PAY_CA_BALANCE_VIEW_PKG dependencies on FND_DATE

Line 1893: SELECT fnd_date.canonical_to_date(org_information11)

1889: ELSIF p_dimension_name like '%Month' THEN
1890: l_expiry_date := next_month(p_owner_effective_date);
1891:
1892: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
1893: SELECT fnd_date.canonical_to_date(org_information11)
1894: INTO l_beg_of_fiscal_year
1895: FROM pay_payroll_actions PACT,
1896: pay_assignment_actions ASSACT,
1897: hr_organization_information HOI

Line 1907: SELECT fnd_date.canonical_to_date(org_information11)

1903: l_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,
1904: p_owner_effective_date);
1905:
1906: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
1907: SELECT fnd_date.canonical_to_date(org_information11)
1908: INTO l_beg_of_fiscal_year
1909: FROM pay_payroll_actions PACT,
1910: pay_assignment_actions ASSACT,
1911: hr_organization_information HOI