188:
189:
190: if ln_start_asg_id is not NULL then
191: lc_start_reason := hr_fr_mmo.get_reason(ln_start_asg_id,
192: fnd_date.date_to_canonical(START_DATE),
193: P_FORMULA_ID,
194: 'S');
195: if (lc_start_reason <> ' ') then
196: C_START_REASON := hruserdt.get_table_value (P_BUSINESS_GROUP_ID,
205: end if;
206:
207: if (ln_end_asg_id is not NULL) then
208: lc_end_reason := hr_fr_mmo.get_reason(ln_end_asg_id,
209: fnd_date.date_to_canonical(END_DATE),
210: P_FORMULA_ID,
211: 'L');
212: if (lc_end_reason <> ' ') then
213: C_END_REASON := hruserdt.get_table_value (P_BUSINESS_GROUP_ID,