DBA Data[Home] [Help]

APPS.GHR_ELT_TO_BEN_PKG dependencies on PAY_UPGRADE_STATUS

Line 74: -- Need to delete the PAY_UPGRADE_STATUS record if the user requested

70: g_proc_name := 'GHR_BEN_EIT_CREATION_'|| l_parent_request_id;
71: l_update_name := 'GHR_ELT_BEN_CONV';
72:
73: --
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

Line 76: DELETE FROM pay_upgrade_status

72:
73: --
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:

Line 187: -- insert the history record in table pay_upgrade_status.

183: p_errbuf := 'There were errors in some person records. Please verify Federal Process Log for details' ;
184: ELSE
185: p_retcode := 0;
186: --
187: -- insert the history record in table pay_upgrade_status.
188: --
189: hr_update_utility.setUpdateProcessing(p_update_name => l_update_name);
190: hr_update_utility.setUpdateComplete(p_update_name => l_update_name);
191: --