APPS.PSP_EXTERNAL_EFFORT_LINES_PKG dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 12: FROM hr_pump_batch_line_user_keys

8: l_external_effort_line_id NUMBER;
9:
10: CURSOR ext_eff_cur IS
11: SELECT unique_key_id
12: FROM hr_pump_batch_line_user_keys
13: WHERE user_key_value = p_ext_effort_line_user_key;
14: BEGIN
15: OPEN ext_eff_cur;
16: FETCH ext_eff_cur INTO l_external_effort_line_id;

Line 38: hr_pump_batch_line_user_keys key

34: l_ovn NUMBER;
35: CURSOR ovn_cur(p_user_key_value IN VARCHAR2) IS
36: SELECT object_version_number
37: FROM psp_external_effort_lines peel,
38: hr_pump_batch_line_user_keys key
39: WHERE key.user_key_value = p_user_key_value
40: AND peel.external_effort_line_id = key.unique_key_id ;
41: BEGIN
42: OPEN ovn_cur(p_ext_effort_line_user_key);