APPS.BEN_PRE_DATAPUMP_PROCESS dependencies on HRDPV_PROCESS_BENEFICIARY

Line 824: from hrdpv_process_beneficiary ch

820: ) is
821: --
822: cursor c_choices is
823: select ch.*
824: from hrdpv_process_beneficiary ch
825: where ch.batch_id = p_batch_id
826: and ch.line_status <> 'C'
827: order by p_person_num,
828: p_employee_number,

Line 888: UPDATE hrdpv_process_beneficiary

884: (which => fnd_file.log,
885: buff => 'Updated Header for ATOMIC_LINKED_CALLS');
886: --
887: --
888: UPDATE hrdpv_process_beneficiary
889: SET P_RECORD_TYP_CD = 'ENROLL'
890: WHERE batch_id = p_batch_id;
891: --
892: --

Line 1043: update hrdpv_process_beneficiary

1039: END IF;
1040: --
1041: IF l_prev_link <> l_link_value AND l_prev_rec.P_RECORD_TYP_CD <> 'POST' THEN
1042: --
1043: update hrdpv_process_beneficiary
1044: set p_record_typ_cd = 'POST'
1045: where batch_id = p_batch_id
1046: and batch_line_id = l_prev_rec.batch_line_id;
1047: --

Line 1051: update hrdpv_process_beneficiary

1047: --
1048: END IF;
1049: --UPDATE STATEMENT
1050: --
1051: update hrdpv_process_beneficiary
1052: set user_sequence = l_sequence ,
1053: link_value = l_link_value
1054: where batch_id = p_batch_id
1055: and batch_line_id = i.batch_line_id ;

Line 1078: update hrdpv_process_beneficiary

1074: end loop;
1075: --
1076: IF l_prev_rec.P_RECORD_TYP_CD <> 'POST' THEN
1077: --
1078: update hrdpv_process_beneficiary
1079: set p_record_typ_cd = 'POST'
1080: where batch_id = p_batch_id
1081: and batch_line_id = l_prev_rec.batch_line_id;
1082: --