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_ANALYZED_ALIEN_DET_BK2 SQL Statements

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

Line: 5


procedure UPDATE_ANALYZED_ALIEN_DET_A
(P_ANALYZED_DATA_DETAILS_ID in NUMBER
,P_ANALYZED_DATA_ID in NUMBER
,P_INCOME_CODE in VARCHAR2
,P_WITHHOLDING_RATE in NUMBER
,P_INCOME_CODE_SUB_TYPE in VARCHAR2
,P_EXEMPTION_CODE in VARCHAR2
,P_MAXIMUM_BENEFIT_AMOUNT in NUMBER
,P_RETRO_LOSE_BEN_AMT_FLAG in VARCHAR2
,P_DATE_BENEFIT_ENDS in DATE
,P_RETRO_LOSE_BEN_DATE_FLAG in VARCHAR2
,P_NRA_EXEMPT_FROM_SS in VARCHAR2
,P_NRA_EXEMPT_FROM_MEDICARE in VARCHAR2
,P_STUDENT_EXEMPT_FROM_SS in VARCHAR2
,P_STUDENT_EXEMPT_FROM_MEDI in VARCHAR2
,P_ADDL_WITHHOLDING_FLAG in VARCHAR2
,P_CONSTANT_ADDL_TAX in NUMBER
,P_ADDL_WITHHOLDING_AMT in NUMBER
,P_ADDL_WTHLDNG_AMT_PERIOD_TYPE in VARCHAR2
,P_PERSONAL_EXEMPTION in NUMBER
,P_ADDL_EXEMPTION_ALLOWED in NUMBER
,P_TREATY_BEN_ALLOWED_FLAG in VARCHAR2
,P_TREATY_BENEFITS_START_DATE in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_RETRO_LOSS_NOTIFICATION_SENT in VARCHAR2
,P_CURRENT_ANALYSIS in VARCHAR2
,P_FORECAST_INCOME_CODE in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PQP_ANALYZED_ALIEN_DET_BK2.UPDATE_ANALYZED_ALIEN_DET_A', 10);

Line: 36


hr_utility.set_location(' Leaving: PQP_ANALYZED_ALIEN_DET_BK2.UPDATE_ANALYZED_ALIEN_DET_A', 20);

Line: 37


end UPDATE_ANALYZED_ALIEN_DET_A;

Line: 38


procedure UPDATE_ANALYZED_ALIEN_DET_B
(P_ANALYZED_DATA_DETAILS_ID in NUMBER
,P_ANALYZED_DATA_ID in NUMBER
,P_INCOME_CODE in VARCHAR2
,P_WITHHOLDING_RATE in NUMBER
,P_INCOME_CODE_SUB_TYPE in VARCHAR2
,P_EXEMPTION_CODE in VARCHAR2
,P_MAXIMUM_BENEFIT_AMOUNT in NUMBER
,P_RETRO_LOSE_BEN_AMT_FLAG in VARCHAR2
,P_DATE_BENEFIT_ENDS in DATE
,P_RETRO_LOSE_BEN_DATE_FLAG in VARCHAR2
,P_NRA_EXEMPT_FROM_SS in VARCHAR2
,P_NRA_EXEMPT_FROM_MEDICARE in VARCHAR2
,P_STUDENT_EXEMPT_FROM_SS in VARCHAR2
,P_STUDENT_EXEMPT_FROM_MEDI in VARCHAR2
,P_ADDL_WITHHOLDING_FLAG in VARCHAR2
,P_CONSTANT_ADDL_TAX in NUMBER
,P_ADDL_WITHHOLDING_AMT in NUMBER
,P_ADDL_WTHLDNG_AMT_PERIOD_TYPE in VARCHAR2
,P_PERSONAL_EXEMPTION in NUMBER
,P_ADDL_EXEMPTION_ALLOWED in NUMBER
,P_TREATY_BEN_ALLOWED_FLAG in VARCHAR2
,P_TREATY_BENEFITS_START_DATE in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_RETRO_LOSS_NOTIFICATION_SENT in VARCHAR2
,P_CURRENT_ANALYSIS in VARCHAR2
,P_FORECAST_INCOME_CODE in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PQP_ANALYZED_ALIEN_DET_BK2.UPDATE_ANALYZED_ALIEN_DET_B', 10);

Line: 69


hr_utility.set_location(' Leaving: PQP_ANALYZED_ALIEN_DET_BK2.UPDATE_ANALYZED_ALIEN_DET_B', 20);

Line: 70


end UPDATE_ANALYZED_ALIEN_DET_B;