DBA Data[Home] [Help]

APPS.GHR_US_NFC_EXTRACTS dependencies on BEN_EXT_RSLT_DTL_S

Line 2585: UPDATE ben_ext_rslt_dtl set val_06 = LPAD(l_rc,8,'0')

2581: CLOSE csr_get_record_count;
2582:
2583: Hr_Utility.set_location('Header Record ID ' ||csr_header_rcd_id.ext_rcd_id, 5);
2584: l_rc :=l_record_count;
2585: UPDATE ben_ext_rslt_dtl set val_06 = LPAD(l_rc,8,'0')
2586: WHERE ext_rcd_id = csr_header_rcd_id.ext_rcd_id
2587: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
2588: AND business_group_id= p_business_group_id;
2589:

Line 4667: select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;

4663: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
4664: -- nocopy changes
4665: l_dtl_rec_nc := p_dtl_rec;
4666: -- Get the next sequence NUMBER to insert a record into the table
4667: select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;
4668: insert into ben_ext_rslt_dtl
4669: (ext_rslt_dtl_id
4670: ,ext_rslt_id
4671: ,business_group_id