APPS.HR_UPDATE_UTILITY dependencies on PAY_UPGRADE_DEFINITIONS

Line 36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

32: l_request_id number := null;
33:
34: l_sql_stmt varchar2(250);
35:
36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;
39:
40: /*

Line 37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

33:
34: l_sql_stmt varchar2(250);
35:
36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;
39:
40: /*
41: ** Local variables for use by get_request_status

Line 38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;

34: l_sql_stmt varchar2(250);
35:
36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;
39:
40: /*
41: ** Local variables for use by get_request_status
42: */

Line 64: from pay_upgrade_definitions

60: cursor csr_get_update_details is
61: select upgrade_definition_id,
62: upgrade_level,
63: upgrade_method
64: from pay_upgrade_definitions
65: where short_name = p_update_name;
66:
67: /*
68: ** This cursor is used to get the status of a GUP

Line 321: from pay_upgrade_definitions

317:
318: cursor csr_get_update_details is
319: select upgrade_definition_id,
320: upgrade_level
321: from pay_upgrade_definitions
322: where short_name = p_update_name;
323:
324: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
325: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

Line 324: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

320: upgrade_level
321: from pay_upgrade_definitions
322: where short_name = p_update_name;
323:
324: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
325: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
326:
327: begin
328:

Line 325: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

321: from pay_upgrade_definitions
322: where short_name = p_update_name;
323:
324: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
325: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
326:
327: begin
328:
329:

Line 358: from pay_upgrade_definitions

354:
355: cursor csr_get_update_details is
356: select upgrade_definition_id,
357: upgrade_level
358: from pay_upgrade_definitions
359: where short_name = p_update_name;
360:
361: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
362: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

Line 361: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

357: upgrade_level
358: from pay_upgrade_definitions
359: where short_name = p_update_name;
360:
361: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
362: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
363:
364: begin
365:

Line 362: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

358: from pay_upgrade_definitions
359: where short_name = p_update_name;
360:
361: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
362: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
363:
364: begin
365:
366: