APPS.GHR_ELT_TO_BEN_PKG dependencies on PAY_UPGRADE_DEFINITIONS

Line 60: l_update_name pay_upgrade_definitions.short_name%type;

56: dphase VARCHAR2(30);
57: dstatus VARCHAR2(30);
58: message VARCHAR2(240);
59: call_status BOOLEAN;
60: l_update_name pay_upgrade_definitions.short_name%type;
61:
62: BEGIN
63: -- Initialization of variables.
64: l_batch_counter := 0;

Line 78: FROM pay_upgrade_definitions

74: -- Need to delete the PAY_UPGRADE_STATUS record if the user requested
75: -- Manual submission of Conc. Request
76: DELETE FROM pay_upgrade_status
77: WHERE upgrade_definition_id = (SELECT upgrade_definition_id
78: FROM pay_upgrade_definitions
79: WHERE short_name = l_update_name);
80:
81: -- Thread size should be minimum of 10.
82: IF p_thread_size IS NULL OR p_thread_size < 10 THEN