APPS.PSP_EXTERNAL_EFFORT_LINES_PKG dependencies on PSP_EXTERNAL_EFFORT_LINES

Line 1: PACKAGE BODY PSP_EXTERNAL_EFFORT_LINES_PKG AS

1: PACKAGE BODY PSP_EXTERNAL_EFFORT_LINES_PKG AS
2: --$Header: PSPHREFB.pls 120.0 2006/02/02 14:27:50 sramacha noship $
3:
4: FUNCTION get_external_effort_line_id
5: ( p_ext_effort_line_user_key IN VARCHAR2)

Line 37: FROM psp_external_effort_lines peel,

33:
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

Line 54: END psp_external_effort_lines_PKG;

50: p_ext_effort_line_user_key);
51: RAISE;
52: END get_external_effort_ovn;
53:
54: END psp_external_effort_lines_PKG;