21: effective_end_date
22: into
23: l_effective_end_date
24: from
25: per_contact_extra_info_f
26: where
27: contact_extra_info_id = p_contact_extra_info_id
28: and
29: p_effective_date
40: 'Y'
41: into
42: l_dummy
43: from
44: per_contact_extra_info_f
45: where
46: contact_extra_info_id = p_contact_extra_info_id
47: and
48: l_effective_end_date + 1
527: l_effective_date date;
528: l_date_track_option varchar2(30);
529:
530: l_tran_tab hr_transaction_ss.transaction_data;
531: l_tran_rec per_contact_extra_info_f%rowtype;
532:
533: i number;
534:
535: begin