DBA Data[Home] [Help]

APPS.PSP_ADJ_DRIVER dependencies on FND_DATE

Line 3382: fnd_date.canonical_to_date(DECODE(trans_type.transaction_type_count,

3378: LINES.element_type_id,
3379: LINES.orig_distribution_date,
3380: -- LINES.effective_date, Commented for bug fix 3927570
3381: -- Introduced the following for bug fix 3892097
3382: fnd_date.canonical_to_date(DECODE(trans_type.transaction_type_count,
3383: 1, fnd_date.date_to_canonical(LINES.effective_date),
3384: DECODE(dest.gl_code_combination_id,
3385: NULL, fnd_date.date_to_canonical(lines.orig_distribution_date),
3386: fnd_date.date_to_canonical(ptp.end_date)))) effective_date,

Line 3383: 1, fnd_date.date_to_canonical(LINES.effective_date),

3379: LINES.orig_distribution_date,
3380: -- LINES.effective_date, Commented for bug fix 3927570
3381: -- Introduced the following for bug fix 3892097
3382: fnd_date.canonical_to_date(DECODE(trans_type.transaction_type_count,
3383: 1, fnd_date.date_to_canonical(LINES.effective_date),
3384: DECODE(dest.gl_code_combination_id,
3385: NULL, fnd_date.date_to_canonical(lines.orig_distribution_date),
3386: fnd_date.date_to_canonical(ptp.end_date)))) effective_date,
3387: -- End of changes for bug fix 3927570

Line 3385: NULL, fnd_date.date_to_canonical(lines.orig_distribution_date),

3381: -- Introduced the following for bug fix 3892097
3382: fnd_date.canonical_to_date(DECODE(trans_type.transaction_type_count,
3383: 1, fnd_date.date_to_canonical(LINES.effective_date),
3384: DECODE(dest.gl_code_combination_id,
3385: NULL, fnd_date.date_to_canonical(lines.orig_distribution_date),
3386: fnd_date.date_to_canonical(ptp.end_date)))) effective_date,
3387: -- End of changes for bug fix 3927570
3388: LINES.distribution_amount * DEST.distribution_percent/100, ------- unrounded, unlimited precision DA_ENH
3389: LINES.dr_cr_flag,

Line 3386: fnd_date.date_to_canonical(ptp.end_date)))) effective_date,

3382: fnd_date.canonical_to_date(DECODE(trans_type.transaction_type_count,
3383: 1, fnd_date.date_to_canonical(LINES.effective_date),
3384: DECODE(dest.gl_code_combination_id,
3385: NULL, fnd_date.date_to_canonical(lines.orig_distribution_date),
3386: fnd_date.date_to_canonical(ptp.end_date)))) effective_date,
3387: -- End of changes for bug fix 3927570
3388: LINES.distribution_amount * DEST.distribution_percent/100, ------- unrounded, unlimited precision DA_ENH
3389: LINES.dr_cr_flag,
3390: l_payroll_control_id,