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
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;
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: --