APPS.GHR_MASS_SEL_NOA dependencies on GHR_MASS_NOA_PREVIEW

Line 1142: INTO ghr_mass_noa_preview (mass_noa_preview_id

1138: l_tot_new_sal := p_tot_new_sal;
1139: END IF;
1140: END IF; --IF g_mcal_flag THEN
1141: INSERT
1142: INTO ghr_mass_noa_preview (mass_noa_preview_id
1143: , mass_action_type
1144: , ui_type
1145: , session_id
1146: , effective_date

Line 1220: VALUES (GHR_MASS_NOA_PREVIEW_S.nextval

1216: , user_attribute17
1217: , user_attribute18
1218: , user_attribute19
1219: , user_attribute20)
1220: VALUES (GHR_MASS_NOA_PREVIEW_S.nextval
1221: , 'MNOA'
1222: , 'FORM'
1223: , userenv ('SESSIONID')
1224: , p_effective_date

Line 5105: DELETE from ghr_mass_noa_preview

5101: p_err_buf out nocopy varchar2) IS
5102:
5103: BEGIN
5104: p_err_buf := null;
5105: DELETE from ghr_mass_noa_preview
5106: WHERE mass_action_type = 'MNOA'
5107: AND session_id = p_session_id;
5108: COMMIT;
5109: