DBA Data[Home] [Help]

APPS.ARP_CONFIRMATION dependencies on FND_DATE

Line 1946: fnd_date.canonical_to_date(greatest(max(ra2.gl_date),

1942: SELECT
1943: decode(ps2.amount_due_remaining + ra.amount_applied,0,'CL','OP'),
1944: decode(ps2.amount_due_remaining + ra.amount_applied,
1945: 0,
1946: fnd_date.canonical_to_date(greatest(max(ra2.gl_date),
1947: nvl(max(decode(adj2.status,
1948: 'A',adj2.gl_date,
1949: nvl(ps2.gl_date,
1950: ps2.trx_date))),

Line 1957: fnd_date.canonical_to_date(greatest(max(ra2.apply_date),

1953: ),
1954: ''),
1955: decode(ps2.amount_due_remaining + ra.amount_applied,
1956: 0,
1957: fnd_date.canonical_to_date(greatest(max(ra2.apply_date),
1958: nvl(max(decode(adj2.status,
1959: 'A',adj2.apply_date,
1960: ps2.trx_date)),
1961: ps2.trx_date),