APPS.PQP_UK_UNION_DEDUCTION dependencies on FND_DATE

Line 164: ,to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-MON')||'-'|| -- Recalculation Date

160: CURSOR csr_get_union_org_info IS
161: SELECT TO_NUMBER(hoi.org_information1) -- Rates Table ID
162: ,tbls.user_table_name -- Rates Table Name
163: ,tbls.range_or_match -- Rates Table Type 'R' or 'M'
164: ,to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-MON')||'-'|| -- Recalculation Date
165: DECODE( -- Compare the recalculation month to the effective month
166: SIGN( -- By checking the difference between
167: (
168: TO_CHAR(fnd_date.canonical_to_date(hoi.org_information2),'MM')

Line 168: TO_CHAR(fnd_date.canonical_to_date(hoi.org_information2),'MM')

164: ,to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-MON')||'-'|| -- Recalculation Date
165: DECODE( -- Compare the recalculation month to the effective month
166: SIGN( -- By checking the difference between
167: (
168: TO_CHAR(fnd_date.canonical_to_date(hoi.org_information2),'MM')
169: -1
170: ) -- The month of the recalculation date less 1
171: -
172: (

Line 266: TO_CHAR(fnd_date.canonical_to_date(hoi.org_information2),'MM')

262: ,-- Recalculation Date
263: DECODE( -- Compare the recalculation month to the effective month
264: SIGN( -- By checking the difference between
265: (
266: TO_CHAR(fnd_date.canonical_to_date(hoi.org_information2),'MM')
267: -1
268: ) -- The month of the recalculation date less 1
269: -
270: (

Line 279: ||'/'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'MM/DD')

275: , TO_CHAR(fnds.effective_date,'YYYY') -- use current year
276: -- Recalculation month >= than current month
277: ,TO_CHAR(fnds.effective_date-365,'YYYY') -- use previous year
278: )
279: ||'/'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'MM/DD')
280: FROM hr_organization_information hoi
281: ,pay_user_tables tbls
282: ,fnd_sessions fnds
283: WHERE hoi.organization_id = p_union_organization_id