APPS.GHR_NFC_POSITION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL_S

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

656: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
657: -- nocopy changes
658: l_dtl_rec_nc := p_dtl_rec;
659: -- Get the next sequence NUMBER to insert a record into the table
660: select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;
661: insert into ben_ext_rslt_dtl
662: (ext_rslt_dtl_id
663: ,ext_rslt_id
664: ,business_group_id

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

3628: CLOSE csr_get_record_count;
3629:
3630: Hr_Utility.set_location('Handling Total Record count ' ||csr_header_rcd_id.ext_rcd_id, 5);
3631: l_rc :=l_record_count;
3632: UPDATE ben_ext_rslt_dtl set val_06 = LPAD(l_rc,8,'0')
3633: WHERE ext_rcd_id = csr_header_rcd_id.ext_rcd_id
3634: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3635: AND business_group_id= p_business_group_id;
3636:

Line 3674: UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val

3670: sort_val :=sort_val+1;
3671:
3672:
3673: IF l_main_rec.val_02 = '2055' THEN
3674: UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val
3675: ,group_val_01 = ' '
3676: WHERE ext_rcd_id = l_main_rec.ext_rcd_id
3677: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3678: AND ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id

Line 3681: UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val

3677: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3678: AND ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
3679: AND business_group_id= p_business_group_id;
3680: ELSE
3681: UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val
3682: WHERE ext_rcd_id = l_main_rec.ext_rcd_id
3683: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
3684: AND ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
3685: AND business_group_id= p_business_group_id;