DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on FND_DATE

Line 1925: SELECT fnd_date.canonical_to_date(org_information11)

1921: ELSIF p_dimension_name like '%Month' THEN
1922: l_expiry_date := next_month(p_owner_effective_date);
1923:
1924: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
1925: SELECT fnd_date.canonical_to_date(org_information11)
1926: INTO l_beg_of_fiscal_year
1927: FROM pay_payroll_actions PACT,
1928: pay_assignment_actions ASSACT,
1929: hr_organization_information HOI

Line 1939: SELECT fnd_date.canonical_to_date(org_information11)

1935: l_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,
1936: p_owner_effective_date);
1937:
1938: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
1939: SELECT fnd_date.canonical_to_date(org_information11)
1940: INTO l_beg_of_fiscal_year
1941: FROM pay_payroll_actions PACT,
1942: pay_assignment_actions ASSACT,
1943: hr_organization_information HOI