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.PAY_US_FEDERAL_TAX_INFO_F_PKG SQL Statements

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEDERAL_TAX_INFO_ID in NUMBER,
  X_EFFECTIVE_START_DATE in DATE,
  X_EFFECTIVE_END_DATE in DATE,
  X_FUTA_WAGE_LIMIT in NUMBER,
  X_FUTA_RATE in NUMBER,
  X_SS_EE_WAGE_LIMIT in NUMBER,
  X_SS_EE_RATE in NUMBER,
  X_SS_ER_WAGE_LIMIT in NUMBER,
  X_SS_ER_RATE in NUMBER,
  X_MEDI_EE_RATE in NUMBER,
  X_MEDI_ER_RATE in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_FED_ATTRIBUTE1 in VARCHAR2,
  X_FED_ATTRIBUTE2 in VARCHAR2,
  X_FED_ATTRIBUTE3 in VARCHAR2,
  X_FED_ATTRIBUTE4 in VARCHAR2,
  X_FED_ATTRIBUTE5 in VARCHAR2,
  X_FED_ATTRIBUTE6 in VARCHAR2,
  X_FED_ATTRIBUTE7 in VARCHAR2,
  X_FED_ATTRIBUTE8 in VARCHAR2,
  X_FED_ATTRIBUTE9 in VARCHAR2,
  X_FED_ATTRIBUTE10 in VARCHAR2,
  X_FED_ATTRIBUTE11 in VARCHAR2,
  X_FED_ATTRIBUTE12 in VARCHAR2,
  X_FED_ATTRIBUTE13 in VARCHAR2,
  X_FED_ATTRIBUTE14 in VARCHAR2,
  X_FED_ATTRIBUTE15 in VARCHAR2,
  X_FED_ATTRIBUTE16 in VARCHAR2,
  X_FED_ATTRIBUTE17 in VARCHAR2,
  X_FED_ATTRIBUTE18 in VARCHAR2,
  X_FED_ATTRIBUTE19 in VARCHAR2,
  X_FED_ATTRIBUTE20 in VARCHAR2,
  X_FED_INFORMATION1 in VARCHAR2,
  X_FED_INFORMATION2 in VARCHAR2,
  X_FED_INFORMATION3 in VARCHAR2,
  X_FED_INFORMATION4 in VARCHAR2,
  X_FED_INFORMATION5 in VARCHAR2,
  X_FED_INFORMATION6 in VARCHAR2,
  X_FED_INFORMATION7 in VARCHAR2,
  X_FED_INFORMATION8 in VARCHAR2,
  X_FED_INFORMATION9 in VARCHAR2,
  X_FED_INFORMATION10 in VARCHAR2,
  X_FED_INFORMATION11 in VARCHAR2,
  X_FED_INFORMATION12 in VARCHAR2,
  X_FED_INFORMATION13 in VARCHAR2,
  X_FED_INFORMATION14 in VARCHAR2,
  X_FED_INFORMATION15 in VARCHAR2,
  X_FED_INFORMATION16 in VARCHAR2,
  X_FED_INFORMATION17 in VARCHAR2,
  X_FED_INFORMATION18 in VARCHAR2,
  X_FED_INFORMATION19 in VARCHAR2,
  X_FED_INFORMATION20 in VARCHAR2,
  X_FED_INFORMATION21 in VARCHAR2,
  X_FED_INFORMATION22 in VARCHAR2,
  X_FED_INFORMATION23 in VARCHAR2,
  X_FED_INFORMATION24 in VARCHAR2,
  X_FED_INFORMATION25 in VARCHAR2,
  X_FED_INFORMATION26 in VARCHAR2,
  X_FED_INFORMATION27 in VARCHAR2,
  X_FED_INFORMATION28 in VARCHAR2,
  X_FED_INFORMATION29 in VARCHAR2,
  X_FED_INFORMATION30 in VARCHAR2,
  X_REQUEST_ID in NUMBER,
  X_FED_INFORMATION_CATEGORY in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from PAY_US_FEDERAL_TAX_INFO_F
    where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
    and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
    and EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE
    ;

Line: 81


  insert into PAY_US_FEDERAL_TAX_INFO_F (
    FEDERAL_TAX_INFO_ID,
    EFFECTIVE_START_DATE,
    EFFECTIVE_END_DATE,
    FUTA_WAGE_LIMIT,
    FUTA_RATE,
    SS_EE_WAGE_LIMIT,
    SS_EE_RATE,
    SS_ER_WAGE_LIMIT,
    SS_ER_RATE,
    MEDI_EE_RATE,
    MEDI_ER_RATE,
    ATTRIBUTE_CATEGORY,
    FED_ATTRIBUTE1,
    FED_ATTRIBUTE2,
    FED_ATTRIBUTE3,
    FED_ATTRIBUTE4,
    FED_ATTRIBUTE5,
    FED_ATTRIBUTE6,
    FED_ATTRIBUTE7,
    FED_ATTRIBUTE8,
    FED_ATTRIBUTE9,
    FED_ATTRIBUTE10,
    FED_ATTRIBUTE11,
    FED_ATTRIBUTE12,
    FED_ATTRIBUTE13,
    FED_ATTRIBUTE14,
    FED_ATTRIBUTE15,
    FED_ATTRIBUTE16,
    FED_ATTRIBUTE17,
    FED_ATTRIBUTE18,
    FED_ATTRIBUTE19,
    FED_ATTRIBUTE20,
    FED_INFORMATION_CATEGORY,
    FED_INFORMATION1,
    FED_INFORMATION2,
    FED_INFORMATION3,
    FED_INFORMATION4,
    FED_INFORMATION5,
    FED_INFORMATION6,
    FED_INFORMATION7,
    FED_INFORMATION8,
    FED_INFORMATION9,
    FED_INFORMATION10,
    FED_INFORMATION11,
    FED_INFORMATION12,
    FED_INFORMATION13,
    FED_INFORMATION14,
    FED_INFORMATION15,
    FED_INFORMATION16,
    FED_INFORMATION17,
    FED_INFORMATION18,
    FED_INFORMATION19,
    FED_INFORMATION20,
    FED_INFORMATION21,
    FED_INFORMATION22,
    FED_INFORMATION23,
    FED_INFORMATION24,
    FED_INFORMATION25,
    FED_INFORMATION26,
    FED_INFORMATION27,
    FED_INFORMATION28,
    FED_INFORMATION29,
    FED_INFORMATION30,
    REQUEST_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_FEDERAL_TAX_INFO_ID,
    X_EFFECTIVE_START_DATE,
    X_EFFECTIVE_END_DATE,
    X_FUTA_WAGE_LIMIT,
    X_FUTA_RATE,
    X_SS_EE_WAGE_LIMIT,
    X_SS_EE_RATE,
    X_SS_ER_WAGE_LIMIT,
    X_SS_ER_RATE,
    X_MEDI_EE_RATE,
    X_MEDI_ER_RATE,
    X_ATTRIBUTE_CATEGORY,
    X_FED_ATTRIBUTE1,
    X_FED_ATTRIBUTE2,
    X_FED_ATTRIBUTE3,
    X_FED_ATTRIBUTE4,
    X_FED_ATTRIBUTE5,
    X_FED_ATTRIBUTE6,
    X_FED_ATTRIBUTE7,
    X_FED_ATTRIBUTE8,
    X_FED_ATTRIBUTE9,
    X_FED_ATTRIBUTE10,
    X_FED_ATTRIBUTE11,
    X_FED_ATTRIBUTE12,
    X_FED_ATTRIBUTE13,
    X_FED_ATTRIBUTE14,
    X_FED_ATTRIBUTE15,
    X_FED_ATTRIBUTE16,
    X_FED_ATTRIBUTE17,
    X_FED_ATTRIBUTE18,
    X_FED_ATTRIBUTE19,
    X_FED_ATTRIBUTE20,
    X_FED_INFORMATION_CATEGORY,
    X_FED_INFORMATION1,
    X_FED_INFORMATION2,
    X_FED_INFORMATION3,
    X_FED_INFORMATION4,
    X_FED_INFORMATION5,
    X_FED_INFORMATION6,
    X_FED_INFORMATION7,
    X_FED_INFORMATION8,
    X_FED_INFORMATION9,
    X_FED_INFORMATION10,
    X_FED_INFORMATION11,
    X_FED_INFORMATION12,
    X_FED_INFORMATION13,
    X_FED_INFORMATION14,
    X_FED_INFORMATION15,
    X_FED_INFORMATION16,
    X_FED_INFORMATION17,
    X_FED_INFORMATION18,
    X_FED_INFORMATION19,
    X_FED_INFORMATION20,
    X_FED_INFORMATION21,
    X_FED_INFORMATION22,
    X_FED_INFORMATION23,
    X_FED_INFORMATION24,
    X_FED_INFORMATION25,
    X_FED_INFORMATION26,
    X_FED_INFORMATION27,
    X_FED_INFORMATION28,
    X_FED_INFORMATION29,
    X_FED_INFORMATION30,
    X_REQUEST_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 226


end INSERT_ROW;

Line: 295


  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
cursor c1(X_FEDERAL_TAX_INFO_ID NUMBER) is
select 'Y'
from PAY_US_FEDERAL_TAX_INFO_F
where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID;

Line: 305


select *
from PAY_US_FEDERAL_TAX_INFO_F
where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
and   X_EFFECTIVE_START_DATE  > EFFECTIVE_START_DATE
and   X_EFFECTIVE_START_DATE < EFFECTIVE_END_DATE
FOR UPDATE OF EFFECTIVE_END_DATE;

Line: 313


select *
from PAY_US_FEDERAL_TAX_INFO_F
where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
and   X_EFFECTIVE_END_DATE  > EFFECTIVE_START_DATE
and   X_EFFECTIVE_END_DATE < EFFECTIVE_END_DATE
FOR UPDATE OF EFFECTIVE_START_DATE;

Line: 324


  update PAY_US_FEDERAL_TAX_INFO_F set
    FUTA_WAGE_LIMIT = X_FUTA_WAGE_LIMIT,
    FUTA_RATE = X_FUTA_RATE,
    SS_EE_WAGE_LIMIT = X_SS_EE_WAGE_LIMIT,
    SS_EE_RATE = X_SS_EE_RATE,
    SS_ER_WAGE_LIMIT = X_SS_ER_WAGE_LIMIT,
    SS_ER_RATE = X_SS_ER_RATE,
    MEDI_EE_RATE = X_MEDI_EE_RATE,
    MEDI_ER_RATE = X_MEDI_ER_RATE,
    FED_INFORMATION_CATEGORY = X_FED_INFORMATION_CATEGORY,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    FED_ATTRIBUTE1 = X_FED_ATTRIBUTE1,
    FED_ATTRIBUTE2 = X_FED_ATTRIBUTE2,
    FED_ATTRIBUTE3 = X_FED_ATTRIBUTE3,
    FED_ATTRIBUTE4 = X_FED_ATTRIBUTE4,
    FED_ATTRIBUTE5 = X_FED_ATTRIBUTE5,
    FED_ATTRIBUTE6 = X_FED_ATTRIBUTE6,
    FED_ATTRIBUTE7 = X_FED_ATTRIBUTE7,
    FED_ATTRIBUTE8 = X_FED_ATTRIBUTE8,
    FED_ATTRIBUTE9 = X_FED_ATTRIBUTE9,
    FED_ATTRIBUTE10 = X_FED_ATTRIBUTE10,
    FED_ATTRIBUTE11 = X_FED_ATTRIBUTE11,
    FED_ATTRIBUTE12 = X_FED_ATTRIBUTE12,
    FED_ATTRIBUTE13 = X_FED_ATTRIBUTE13,
    FED_ATTRIBUTE14 = X_FED_ATTRIBUTE14,
    FED_ATTRIBUTE15 = X_FED_ATTRIBUTE15,
    FED_ATTRIBUTE16 = X_FED_ATTRIBUTE16,
    FED_ATTRIBUTE17 = X_FED_ATTRIBUTE17,
    FED_ATTRIBUTE18 = X_FED_ATTRIBUTE18,
    FED_ATTRIBUTE19 = X_FED_ATTRIBUTE19,
    FED_ATTRIBUTE20 = X_FED_ATTRIBUTE20,
    FED_INFORMATION1 = X_FED_INFORMATION1,
    FED_INFORMATION2 = X_FED_INFORMATION2,
    FED_INFORMATION3 = X_FED_INFORMATION3,
    FED_INFORMATION4 = X_FED_INFORMATION4,
    FED_INFORMATION5 = X_FED_INFORMATION5,
    FED_INFORMATION6 = X_FED_INFORMATION6,
    FED_INFORMATION7 = X_FED_INFORMATION7,
    FED_INFORMATION8 = X_FED_INFORMATION8,
    FED_INFORMATION9 = X_FED_INFORMATION9,
    FED_INFORMATION10 = X_FED_INFORMATION10,
    FED_INFORMATION11 = X_FED_INFORMATION11,
    FED_INFORMATION12 = X_FED_INFORMATION12,
    FED_INFORMATION13 = X_FED_INFORMATION13,
    FED_INFORMATION14 = X_FED_INFORMATION14,
    FED_INFORMATION15 = X_FED_INFORMATION15,
    FED_INFORMATION16 = X_FED_INFORMATION16,
    FED_INFORMATION17 = X_FED_INFORMATION17,
    FED_INFORMATION18 = X_FED_INFORMATION18,
    FED_INFORMATION19 = X_FED_INFORMATION19,
    FED_INFORMATION20 = X_FED_INFORMATION20,
    FED_INFORMATION21 = X_FED_INFORMATION21,
    FED_INFORMATION22 = X_FED_INFORMATION22,
    FED_INFORMATION23 = X_FED_INFORMATION23,
    FED_INFORMATION24 = X_FED_INFORMATION24,
    FED_INFORMATION25 = X_FED_INFORMATION25,
    FED_INFORMATION26 = X_FED_INFORMATION26,
    FED_INFORMATION27 = X_FED_INFORMATION27,
    FED_INFORMATION28 = X_FED_INFORMATION28,
    FED_INFORMATION29 = X_FED_INFORMATION29,
    FED_INFORMATION30 = X_FED_INFORMATION30,
    REQUEST_ID = X_REQUEST_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
  and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
  and EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE;

Line: 403


              UPDATE PAY_US_FEDERAL_TAX_INFO_F
              SET EFFECTIVE_END_DATE = X_EFFECTIVE_START_DATE -1
              WHERE CURRENT OF c2;

Line: 412


              UPDATE PAY_US_FEDERAL_TAX_INFO_F
              SET EFFECTIVE_START_DATE = X_EFFECTIVE_END_DATE +1
              WHERE CURRENT OF c3;

Line: 421


	  PAY_US_FEDERAL_TAX_INFO_F_PKG.INSERT_ROW(
            X_ROWID => l_rowid,
	    X_FEDERAL_TAX_INFO_ID => X_FEDERAL_TAX_INFO_ID,
	    X_EFFECTIVE_START_DATE => X_EFFECTIVE_START_DATE,
	    X_EFFECTIVE_END_DATE => X_EFFECTIVE_END_DATE,
	    X_FUTA_WAGE_LIMIT => X_FUTA_WAGE_LIMIT,
	    X_FUTA_RATE => X_FUTA_RATE,
	    X_SS_EE_WAGE_LIMIT => X_SS_EE_WAGE_LIMIT,
	    X_SS_EE_RATE => X_SS_EE_RATE,
	    X_SS_ER_WAGE_LIMIT => X_SS_ER_WAGE_LIMIT,
	    X_SS_ER_RATE => X_SS_ER_RATE,
	    X_MEDI_EE_RATE => X_MEDI_EE_RATE,
	    X_MEDI_ER_RATE => X_MEDI_ER_RATE,
	    X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
	    X_FED_ATTRIBUTE1 => X_FED_ATTRIBUTE1,
	    X_FED_ATTRIBUTE2 => X_FED_ATTRIBUTE2,
	    X_FED_ATTRIBUTE3 => X_FED_ATTRIBUTE3,
	    X_FED_ATTRIBUTE4 => X_FED_ATTRIBUTE4,
	    X_FED_ATTRIBUTE5 => X_FED_ATTRIBUTE5,
	    X_FED_ATTRIBUTE6 => X_FED_ATTRIBUTE6,
	    X_FED_ATTRIBUTE7 => X_FED_ATTRIBUTE7,
	    X_FED_ATTRIBUTE8 => X_FED_ATTRIBUTE8,
	    X_FED_ATTRIBUTE9 => X_FED_ATTRIBUTE9,
	    X_FED_ATTRIBUTE10 => X_FED_ATTRIBUTE10,
	    X_FED_ATTRIBUTE11 => X_FED_ATTRIBUTE11,
	    X_FED_ATTRIBUTE12 => X_FED_ATTRIBUTE12,
	    X_FED_ATTRIBUTE13 => X_FED_ATTRIBUTE13,
	    X_FED_ATTRIBUTE14 => X_FED_ATTRIBUTE14,
	    X_FED_ATTRIBUTE15 => X_FED_ATTRIBUTE15,
	    X_FED_ATTRIBUTE16 => X_FED_ATTRIBUTE16,
	    X_FED_ATTRIBUTE17 => X_FED_ATTRIBUTE17,
	    X_FED_ATTRIBUTE18 => X_FED_ATTRIBUTE18,
	    X_FED_ATTRIBUTE19 => X_FED_ATTRIBUTE19,
	    X_FED_ATTRIBUTE20 => X_FED_ATTRIBUTE20,
	    X_FED_INFORMATION1 => X_FED_INFORMATION1,
	    X_FED_INFORMATION2 => X_FED_INFORMATION2,
	    X_FED_INFORMATION3 => X_FED_INFORMATION3,
	    X_FED_INFORMATION4 => X_FED_INFORMATION4,
	    X_FED_INFORMATION5 => X_FED_INFORMATION5,
	    X_FED_INFORMATION6 => X_FED_INFORMATION6,
	    X_FED_INFORMATION7 => X_FED_INFORMATION7,
	    X_FED_INFORMATION8 => X_FED_INFORMATION8,
	    X_FED_INFORMATION9 => X_FED_INFORMATION9,
	    X_FED_INFORMATION10 => X_FED_INFORMATION10,
	    X_FED_INFORMATION11 => X_FED_INFORMATION11,
	    X_FED_INFORMATION12 => X_FED_INFORMATION12,
	    X_FED_INFORMATION13 => X_FED_INFORMATION13,
	    X_FED_INFORMATION14 => X_FED_INFORMATION14,
	    X_FED_INFORMATION15 => X_FED_INFORMATION15,
	    X_FED_INFORMATION16 => X_FED_INFORMATION16,
	    X_FED_INFORMATION17 => X_FED_INFORMATION17,
	    X_FED_INFORMATION18 => X_FED_INFORMATION18,
	    X_FED_INFORMATION19 => X_FED_INFORMATION19,
	    X_FED_INFORMATION20 => X_FED_INFORMATION20,
	    X_FED_INFORMATION21 => X_FED_INFORMATION21,
	    X_FED_INFORMATION22 => X_FED_INFORMATION22,
	    X_FED_INFORMATION23 => X_FED_INFORMATION23,
	    X_FED_INFORMATION24 => X_FED_INFORMATION24,
	    X_FED_INFORMATION25 => X_FED_INFORMATION25,
	    X_FED_INFORMATION26 => X_FED_INFORMATION26,
	    X_FED_INFORMATION27 => X_FED_INFORMATION27,
	    X_FED_INFORMATION28 => X_FED_INFORMATION28,
	    X_FED_INFORMATION29 => X_FED_INFORMATION29,
	    X_FED_INFORMATION30 => X_FED_INFORMATION30,
	    X_REQUEST_ID => X_REQUEST_ID,
            X_CREATION_DATE => X_CREATION_DATE,
            X_CREATED_BY => X_CREATED_BY,
	    X_FED_INFORMATION_CATEGORY => X_FED_INFORMATION_CATEGORY,
	    X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
	    X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
	    X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN);

Line: 496


procedure DELETE_ROW (
  X_FEDERAL_TAX_INFO_ID in NUMBER,
  X_EFFECTIVE_START_DATE in DATE,
  X_EFFECTIVE_END_DATE in DATE
) is
begin
  delete from PAY_US_FEDERAL_TAX_INFO_F
  where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
  and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
  and EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE;

Line: 510


end DELETE_ROW;