APPS.PAY_HK_SOE_PKG dependencies on FND_DATE

Line 464: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')

460: , NULL
461: , NULL
462: , NULL
463: , NULL
464: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
465: , NULL
466: , NULL)
467: , fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
468: , TO_CHAR(pay_balance_pkg.get_value( pdb_ytd.defined_balance_id

Line 475: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')

471: , NULL
472: , NULL
473: , NULL
474: , NULL
475: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
476: , NULL
477: , NULL)
478: , fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
479: FROM pay_balance_types pbt

Line 726: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')

722: , NULL
723: , NULL
724: , NULL
725: , NULL
726: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
727: , NULL
728: , NULL)
729: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
730: FROM pay_defined_balances pdb

Line 744: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')

740: , NULL
741: , NULL
742: , NULL
743: , NULL
744: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
745: , NULL
746: , NULL) <> 0';
747:
748: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_balance_information');