APPS.PQP_NL_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL_S

Line 1573: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;

1569: END IF;
1570: -- nocopy changes
1571: l_dtl_rec_nc := p_dtl_rec;
1572: -- Get the next sequence NUMBER to insert a record into the table
1573: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1574:
1575: INSERT INTO ben_ext_rslt_dtl
1576: (EXT_RSLT_DTL_ID
1577: ,EXT_RSLT_ID

Line 12634: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;

12630: ,p_effective_date
12631: ,p_error_message
12632: ,l_seq_num);
12633:
12634: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;
12635:
12636: INSERT INTO ben_ext_rslt_dtl
12637: ( EXT_RSLT_DTL_ID
12638: ,EXT_RSLT_ID

Line 12737: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;

12733: ,c_ext_dtl_rcd_id => l_rcd_id);
12734: FETCH csr_rslt_dtl INTO l_main_rec;
12735: CLOSE csr_rslt_dtl;
12736:
12737: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO l_ext_rslt_dtl_id FROM dual;
12738:
12739: INSERT INTO ben_ext_rslt_dtl
12740: ( EXT_RSLT_DTL_ID
12741: ,EXT_RSLT_ID