APPS.PAY_HK_SOE_PKG dependencies on FND_DATE

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

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

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

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

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

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

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

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