112: DECODE (p_rec.pil_elctbl_popl_stat_cd, NULL, 1, 0),
113: DECODE (p_rec.elcns_made_dt, NULL, 0, 1),
114: DECODE (p_rec.dflt_enrt_dt, NULL, 0, 1),
115: SYSDATE,
116: fnd_global.user_id,
117: fnd_global.login_id,
118: fnd_global.user_id,
119: SYSDATE
120: );
113: DECODE (p_rec.elcns_made_dt, NULL, 0, 1),
114: DECODE (p_rec.dflt_enrt_dt, NULL, 0, 1),
115: SYSDATE,
116: fnd_global.user_id,
117: fnd_global.login_id,
118: fnd_global.user_id,
119: SYSDATE
120: );
121: END IF;
114: DECODE (p_rec.dflt_enrt_dt, NULL, 0, 1),
115: SYSDATE,
116: fnd_global.user_id,
117: fnd_global.login_id,
118: fnd_global.user_id,
119: SYSDATE
120: );
121: END IF;
122:
187: ),
188: DECODE (pel_rec.elcns_made_dt, NULL, 0, 1),
189: DECODE (pel_rec.dflt_enrt_dt, NULL, 0, 1),
190: SYSDATE,
191: fnd_global.user_id,
192: fnd_global.login_id,
193: fnd_global.user_id,
194: SYSDATE
195: );
188: DECODE (pel_rec.elcns_made_dt, NULL, 0, 1),
189: DECODE (pel_rec.dflt_enrt_dt, NULL, 0, 1),
190: SYSDATE,
191: fnd_global.user_id,
192: fnd_global.login_id,
193: fnd_global.user_id,
194: SYSDATE
195: );
196: END LOOP;
189: DECODE (pel_rec.dflt_enrt_dt, NULL, 0, 1),
190: SYSDATE,
191: fnd_global.user_id,
192: fnd_global.login_id,
193: fnd_global.user_id,
194: SYSDATE
195: );
196: END LOOP;
197: END IF;
220: p_pil_rec.business_group_id, -1,
221: p_effective_date,
222: 'ZAP',
223: SYSDATE,
224: fnd_global.user_id,
225: fnd_global.login_id,
226: fnd_global.user_id,
227: SYSDATE
228: );
221: p_effective_date,
222: 'ZAP',
223: SYSDATE,
224: fnd_global.user_id,
225: fnd_global.login_id,
226: fnd_global.user_id,
227: SYSDATE
228: );
229: END IF;
222: 'ZAP',
223: SYSDATE,
224: fnd_global.user_id,
225: fnd_global.login_id,
226: fnd_global.user_id,
227: SYSDATE
228: );
229: END IF;
230: END IF;