DBA Data[Home] [Help]

APPS.PAY_KR_PROCESS_NAV_PKG dependencies on FND_DATE

Line 193: fnd_date.date_to_canonical(

189: and organization_id = p_business_place_id ;
190: --
191: cursor csr_bonus_start_date is
192: select 'BONUS_PERIOD_START_DATE=' ||
193: fnd_date.date_to_canonical(
194: greatest(fnd_date.canonical_to_date(p_bonus_start_date),
195: trunc(fnd_date.canonical_to_date(p_date_earned), 'YYYY')
196: )
197: ) a_bonus_start_date_hd

Line 194: greatest(fnd_date.canonical_to_date(p_bonus_start_date),

190: --
191: cursor csr_bonus_start_date is
192: select 'BONUS_PERIOD_START_DATE=' ||
193: fnd_date.date_to_canonical(
194: greatest(fnd_date.canonical_to_date(p_bonus_start_date),
195: trunc(fnd_date.canonical_to_date(p_date_earned), 'YYYY')
196: )
197: ) a_bonus_start_date_hd
198: from dual;

Line 195: trunc(fnd_date.canonical_to_date(p_date_earned), 'YYYY')

191: cursor csr_bonus_start_date is
192: select 'BONUS_PERIOD_START_DATE=' ||
193: fnd_date.date_to_canonical(
194: greatest(fnd_date.canonical_to_date(p_bonus_start_date),
195: trunc(fnd_date.canonical_to_date(p_date_earned), 'YYYY')
196: )
197: ) a_bonus_start_date_hd
198: from dual;
199: --