DBA Data[Home] [Help]

APPS.PSP_ADJ_DRIVER dependencies on FND_DATE

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

3369: LINES.element_type_id,
3370: LINES.orig_distribution_date,
3371: -- LINES.effective_date, Commented for bug fix 3927570
3372: -- Introduced the following for bug fix 3892097
3373: fnd_date.canonical_to_date(DECODE(trans_type.transaction_type_count,
3374: 1, fnd_date.date_to_canonical(LINES.effective_date),
3375: DECODE(dest.gl_code_combination_id,
3376: NULL, fnd_date.date_to_canonical(lines.orig_distribution_date),
3377: fnd_date.date_to_canonical(ptp.end_date)))) effective_date,

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

3370: LINES.orig_distribution_date,
3371: -- LINES.effective_date, Commented for bug fix 3927570
3372: -- Introduced the following for bug fix 3892097
3373: fnd_date.canonical_to_date(DECODE(trans_type.transaction_type_count,
3374: 1, fnd_date.date_to_canonical(LINES.effective_date),
3375: DECODE(dest.gl_code_combination_id,
3376: NULL, fnd_date.date_to_canonical(lines.orig_distribution_date),
3377: fnd_date.date_to_canonical(ptp.end_date)))) effective_date,
3378: -- End of changes for bug fix 3927570

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

3372: -- Introduced the following for bug fix 3892097
3373: fnd_date.canonical_to_date(DECODE(trans_type.transaction_type_count,
3374: 1, fnd_date.date_to_canonical(LINES.effective_date),
3375: DECODE(dest.gl_code_combination_id,
3376: NULL, fnd_date.date_to_canonical(lines.orig_distribution_date),
3377: fnd_date.date_to_canonical(ptp.end_date)))) effective_date,
3378: -- End of changes for bug fix 3927570
3379: LINES.distribution_amount * DEST.distribution_percent/100, ------- unrounded, unlimited precision DA_ENH
3380: LINES.dr_cr_flag,

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

3373: fnd_date.canonical_to_date(DECODE(trans_type.transaction_type_count,
3374: 1, fnd_date.date_to_canonical(LINES.effective_date),
3375: DECODE(dest.gl_code_combination_id,
3376: NULL, fnd_date.date_to_canonical(lines.orig_distribution_date),
3377: fnd_date.date_to_canonical(ptp.end_date)))) effective_date,
3378: -- End of changes for bug fix 3927570
3379: LINES.distribution_amount * DEST.distribution_percent/100, ------- unrounded, unlimited precision DA_ENH
3380: LINES.dr_cr_flag,
3381: l_payroll_control_id,