DBA Data[Home] [Help]

APPS.ARP_CONFIRMATION dependencies on FND_DATE

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

1959: SELECT
1960: decode(ps2.amount_due_remaining + ra.amount_applied,0,'CL','OP'),
1961: decode(ps2.amount_due_remaining + ra.amount_applied,
1962: 0,
1963: fnd_date.canonical_to_date(greatest(max(ra2.gl_date),
1964: nvl(max(decode(adj2.status,
1965: 'A',adj2.gl_date,
1966: nvl(ps2.gl_date,
1967: ps2.trx_date))),

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

1970: ),
1971: ''),
1972: decode(ps2.amount_due_remaining + ra.amount_applied,
1973: 0,
1974: fnd_date.canonical_to_date(greatest(max(ra2.apply_date),
1975: nvl(max(decode(adj2.status,
1976: 'A',adj2.apply_date,
1977: ps2.trx_date)),
1978: ps2.trx_date),