eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_DET_RKD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5


procedure AFTER_DELETE
(P_ANALYZED_DATA_DETAILS_ID in NUMBER
,P_ANALYZED_DATA_ID_O in NUMBER
,P_INCOME_CODE_O in VARCHAR2
,P_WITHHOLDING_RATE_O in NUMBER
,P_INCOME_CODE_SUB_TYPE_O in VARCHAR2
,P_EXEMPTION_CODE_O in VARCHAR2
,P_MAXIMUM_BENEFIT_AMOUNT_O in NUMBER
,P_RETRO_LOSE_BEN_AMT_FLAG_O in VARCHAR2
,P_DATE_BENEFIT_ENDS_O in DATE
,P_RETRO_LOSE_BEN_DATE_FLAG_O in VARCHAR2
,P_NRA_EXEMPT_FROM_SS_O in VARCHAR2
,P_NRA_EXEMPT_FROM_MEDICARE_O in VARCHAR2
,P_STUDENT_EXEMPT_FROM_SS_O in VARCHAR2
,P_STUDENT_EXEMPT_FROM_MEDI_O in VARCHAR2
,P_ADDL_WITHHOLDING_FLAG_O in VARCHAR2
,P_CONSTANT_ADDL_TAX_O in NUMBER
,P_ADDL_WITHHOLDING_AMT_O in NUMBER
,P_ADDL_WTHLDNG_AMT_PERIOD_TY_O in VARCHAR2
,P_PERSONAL_EXEMPTION_O in NUMBER
,P_ADDL_EXEMPTION_ALLOWED_O in NUMBER
,P_TREATY_BEN_ALLOWED_FLAG_O in VARCHAR2
,P_TREATY_BENEFITS_START_DATE_O in DATE
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_RETRO_LOSS_NOTIF_SENT_O in VARCHAR2
,P_CURRENT_ANALYSIS_O in VARCHAR2
,P_FORECAST_INCOME_CODE_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PQP_DET_RKD.AFTER_DELETE', 10);

Line: 35


hr_utility.set_location(' Leaving: PQP_DET_RKD.AFTER_DELETE', 20);

Line: 36


end AFTER_DELETE;