DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on FND_DATE

Line 1901: SELECT fnd_date.canonical_to_date(org_information11)

1897: ELSIF p_dimension_name like '%Month' THEN
1898: l_expiry_date := next_month(p_owner_effective_date);
1899:
1900: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
1901: SELECT fnd_date.canonical_to_date(org_information11)
1902: INTO l_beg_of_fiscal_year
1903: FROM pay_payroll_actions PACT,
1904: pay_assignment_actions ASSACT,
1905: hr_organization_information HOI

Line 1915: SELECT fnd_date.canonical_to_date(org_information11)

1911: l_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,
1912: p_owner_effective_date);
1913:
1914: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
1915: SELECT fnd_date.canonical_to_date(org_information11)
1916: INTO l_beg_of_fiscal_year
1917: FROM pay_payroll_actions PACT,
1918: pay_assignment_actions ASSACT,
1919: hr_organization_information HOI