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.

VIEW: APPS.HRDPV_CREATE_AC_EMPTAXRULE

Source

View Text - Preformatted


select batch_id            batch_id
,      batch_line_id       batch_line_id
,      api_module_id       api_module_id
,      line_status         line_status
,      user_sequence       user_sequence
,      link_value          link_value
,      business_group_name business_group_name,
       pval001 P_BUSINESS_GROUP,
       pval002 P_EFFECTIVE_DATE,
       pval003 P_EMPLOYEE,
       pval004 P_ASSIGNMENT,
       pval005 P_LEGISLATION,
       pval006 P_SPREADSHEET_IDENTIFIER,
       pval007 P_SUI_STATE,
       pval008 P_STATE_PROV_CODE,
       pval009 P_COUNTY,
       pval010 P_CITY,
       pval011 P_OVERRIDE_PROV_OF_EMPLT,
       pval012 P_BASIC_AMT_FLAG,
       pval013 P_BASIC_AMT,
       pval014 P_TAX_CREDIT,
       pval015 P_FILING_STATUS_CODE,
       pval016 P_ALLOWANCES,
       pval017 P_ADDITIONAL_TAX,
       pval018 P_SECONDARY_ALLOWANCES,
       pval019 P_EXEMPTION_AMT,
       pval020 P_SIT_OPTIONAL_CALC_IND,
       pval021 P_ADDTL_ALLOWANCE_RATE,
       pval022 P_PRES_ZONE_DEDN,
       pval023 P_TAX_EXEMPT1,
       pval024 P_TAX_EXEMPT2,
       pval025 P_TAX_EXEMPT3,
       pval026 P_TAX_EXEMPT4,
       pval027 P_OVERRIDE_RATE,
       pval028 P_OVERRIDE_AMOUNT,
       pval029 P_OVERRIDE_SUPP_RATE,
       pval030 P_ANNUAL_DEDN,
       pval031 P_LABOR_FUND_CONTR,
       pval032 P_ALLOWANCE_REJECT_DATE,
       pval033 P_EIC_FILING_STATUS,
       pval034 P_STATUTORY_EMPLOYEE,
       pval035 P_CUMULATIVE_TAXATION,
       pval036 P_NON_RESIDENT,
       pval037 P_SUI_BASE_OVERRIDE_AMOUNT,
       pval038 P_SCHOOL_DISTRICT,
       pval039 P_COMM_RENUMERATION,
       pval040 P_COMM_EXPENSES,
       pval041 P_SPOUSE_OR_EQUIVALENT,
       pval042 P_DISABILITY_STATUS,
       pval043 P_NUMBER_OF_DEPENDENTS,
       pval044 P_NUMBER_OF_INFIRM_DEPENDENTS,
       pval045 P_STA_INFORMATION_CATEGORY,
       pval046 P_STA_INFORMATION1,
       pval047 P_STA_INFORMATION2,
       pval048 P_STA_INFORMATION3,
       pval049 P_STA_INFORMATION4,
       pval050 P_STA_INFORMATION5,
       pval051 P_STA_INFORMATION6,
       pval052 P_STA_INFORMATION7,
       pval053 P_STA_INFORMATION8,
       pval054 P_STA_INFORMATION9,
       pval055 P_STA_INFORMATION10,
       pval056 P_STA_INFORMATION11,
       pval057 P_STA_INFORMATION12,
       pval058 P_STA_INFORMATION13,
       pval059 P_STA_INFORMATION14,
       pval060 P_STA_INFORMATION15,
       pval061 P_STA_INFORMATION16,
       pval062 P_STA_INFORMATION17,
       pval063 P_STA_INFORMATION18,
       pval064 P_STA_INFORMATION19,
       pval065 P_STA_INFORMATION20,
       pval066 P_STA_INFORMATION21,
       pval067 P_STA_INFORMATION22,
       pval068 P_STA_INFORMATION23,
       pval069 P_STA_INFORMATION24,
       pval070 P_STA_INFORMATION25,
       pval071 P_STA_INFORMATION26,
       pval072 P_STA_INFORMATION27,
       pval073 P_STA_INFORMATION28,
       pval074 P_STA_INFORMATION29,
       pval075 P_STA_INFORMATION30,
       pval076 P_CA_TAX_INFORMATION_CATEGORY,
       pval077 P_CA_TAX_INFORMATION1,
       pval078 P_CA_TAX_INFORMATION2,
       pval079 P_CA_TAX_INFORMATION3,
       pval080 P_CA_TAX_INFORMATION4,
       pval081 P_CA_TAX_INFORMATION5,
       pval082 P_CA_TAX_INFORMATION6,
       pval083 P_CA_TAX_INFORMATION7,
       pval084 P_CA_TAX_INFORMATION8,
       pval085 P_CA_TAX_INFORMATION9,
       pval086 P_CA_TAX_INFORMATION10,
       pval087 P_CA_TAX_INFORMATION11,
       pval088 P_CA_TAX_INFORMATION12,
       pval089 P_CA_TAX_INFORMATION13,
       pval090 P_CA_TAX_INFORMATION14,
       pval091 P_CA_TAX_INFORMATION15,
       pval092 P_CA_TAX_INFORMATION16,
       pval093 P_CA_TAX_INFORMATION17,
       pval094 P_CA_TAX_INFORMATION18,
       pval095 P_CA_TAX_INFORMATION19,
       pval096 P_CA_TAX_INFORMATION20,
       pval097 P_CA_TAX_INFORMATION21,
       pval098 P_CA_TAX_INFORMATION22,
       pval099 P_CA_TAX_INFORMATION23,
       pval100 P_CA_TAX_INFORMATION24,
       pval101 P_CA_TAX_INFORMATION25,
       pval102 P_CA_TAX_INFORMATION26,
       pval103 P_CA_TAX_INFORMATION27,
       pval104 P_CA_TAX_INFORMATION28,
       pval105 P_CA_TAX_INFORMATION29,
       pval106 P_CA_TAX_INFORMATION30,
       pval107 P_ADDITIONAL_INFO1,
       pval108 P_ADDITIONAL_INFO2,
       pval109 P_ADDITIONAL_INFO3,
       pval110 P_ADDITIONAL_INFO4,
       pval111 P_ADDITIONAL_INFO5,
       pval112 P_ADDITIONAL_INFO6,
       pval113 P_ADDITIONAL_INFO7,
       pval114 P_ADDITIONAL_INFO8,
       pval115 P_ADDITIONAL_INFO9,
       pval116 P_ADDITIONAL_INFO10
from hr_pump_batch_lines
where api_module_id = 3848
with check option

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, API_MODULE_ID API_MODULE_ID
, LINE_STATUS LINE_STATUS
, USER_SEQUENCE USER_SEQUENCE
, LINK_VALUE LINK_VALUE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PVAL001 P_BUSINESS_GROUP
, PVAL002 P_EFFECTIVE_DATE
, PVAL003 P_EMPLOYEE
, PVAL004 P_ASSIGNMENT
, PVAL005 P_LEGISLATION
, PVAL006 P_SPREADSHEET_IDENTIFIER
, PVAL007 P_SUI_STATE
, PVAL008 P_STATE_PROV_CODE
, PVAL009 P_COUNTY
, PVAL010 P_CITY
, PVAL011 P_OVERRIDE_PROV_OF_EMPLT
, PVAL012 P_BASIC_AMT_FLAG
, PVAL013 P_BASIC_AMT
, PVAL014 P_TAX_CREDIT
, PVAL015 P_FILING_STATUS_CODE
, PVAL016 P_ALLOWANCES
, PVAL017 P_ADDITIONAL_TAX
, PVAL018 P_SECONDARY_ALLOWANCES
, PVAL019 P_EXEMPTION_AMT
, PVAL020 P_SIT_OPTIONAL_CALC_IND
, PVAL021 P_ADDTL_ALLOWANCE_RATE
, PVAL022 P_PRES_ZONE_DEDN
, PVAL023 P_TAX_EXEMPT1
, PVAL024 P_TAX_EXEMPT2
, PVAL025 P_TAX_EXEMPT3
, PVAL026 P_TAX_EXEMPT4
, PVAL027 P_OVERRIDE_RATE
, PVAL028 P_OVERRIDE_AMOUNT
, PVAL029 P_OVERRIDE_SUPP_RATE
, PVAL030 P_ANNUAL_DEDN
, PVAL031 P_LABOR_FUND_CONTR
, PVAL032 P_ALLOWANCE_REJECT_DATE
, PVAL033 P_EIC_FILING_STATUS
, PVAL034 P_STATUTORY_EMPLOYEE
, PVAL035 P_CUMULATIVE_TAXATION
, PVAL036 P_NON_RESIDENT
, PVAL037 P_SUI_BASE_OVERRIDE_AMOUNT
, PVAL038 P_SCHOOL_DISTRICT
, PVAL039 P_COMM_RENUMERATION
, PVAL040 P_COMM_EXPENSES
, PVAL041 P_SPOUSE_OR_EQUIVALENT
, PVAL042 P_DISABILITY_STATUS
, PVAL043 P_NUMBER_OF_DEPENDENTS
, PVAL044 P_NUMBER_OF_INFIRM_DEPENDENTS
, PVAL045 P_STA_INFORMATION_CATEGORY
, PVAL046 P_STA_INFORMATION1
, PVAL047 P_STA_INFORMATION2
, PVAL048 P_STA_INFORMATION3
, PVAL049 P_STA_INFORMATION4
, PVAL050 P_STA_INFORMATION5
, PVAL051 P_STA_INFORMATION6
, PVAL052 P_STA_INFORMATION7
, PVAL053 P_STA_INFORMATION8
, PVAL054 P_STA_INFORMATION9
, PVAL055 P_STA_INFORMATION10
, PVAL056 P_STA_INFORMATION11
, PVAL057 P_STA_INFORMATION12
, PVAL058 P_STA_INFORMATION13
, PVAL059 P_STA_INFORMATION14
, PVAL060 P_STA_INFORMATION15
, PVAL061 P_STA_INFORMATION16
, PVAL062 P_STA_INFORMATION17
, PVAL063 P_STA_INFORMATION18
, PVAL064 P_STA_INFORMATION19
, PVAL065 P_STA_INFORMATION20
, PVAL066 P_STA_INFORMATION21
, PVAL067 P_STA_INFORMATION22
, PVAL068 P_STA_INFORMATION23
, PVAL069 P_STA_INFORMATION24
, PVAL070 P_STA_INFORMATION25
, PVAL071 P_STA_INFORMATION26
, PVAL072 P_STA_INFORMATION27
, PVAL073 P_STA_INFORMATION28
, PVAL074 P_STA_INFORMATION29
, PVAL075 P_STA_INFORMATION30
, PVAL076 P_CA_TAX_INFORMATION_CATEGORY
, PVAL077 P_CA_TAX_INFORMATION1
, PVAL078 P_CA_TAX_INFORMATION2
, PVAL079 P_CA_TAX_INFORMATION3
, PVAL080 P_CA_TAX_INFORMATION4
, PVAL081 P_CA_TAX_INFORMATION5
, PVAL082 P_CA_TAX_INFORMATION6
, PVAL083 P_CA_TAX_INFORMATION7
, PVAL084 P_CA_TAX_INFORMATION8
, PVAL085 P_CA_TAX_INFORMATION9
, PVAL086 P_CA_TAX_INFORMATION10
, PVAL087 P_CA_TAX_INFORMATION11
, PVAL088 P_CA_TAX_INFORMATION12
, PVAL089 P_CA_TAX_INFORMATION13
, PVAL090 P_CA_TAX_INFORMATION14
, PVAL091 P_CA_TAX_INFORMATION15
, PVAL092 P_CA_TAX_INFORMATION16
, PVAL093 P_CA_TAX_INFORMATION17
, PVAL094 P_CA_TAX_INFORMATION18
, PVAL095 P_CA_TAX_INFORMATION19
, PVAL096 P_CA_TAX_INFORMATION20
, PVAL097 P_CA_TAX_INFORMATION21
, PVAL098 P_CA_TAX_INFORMATION22
, PVAL099 P_CA_TAX_INFORMATION23
, PVAL100 P_CA_TAX_INFORMATION24
, PVAL101 P_CA_TAX_INFORMATION25
, PVAL102 P_CA_TAX_INFORMATION26
, PVAL103 P_CA_TAX_INFORMATION27
, PVAL104 P_CA_TAX_INFORMATION28
, PVAL105 P_CA_TAX_INFORMATION29
, PVAL106 P_CA_TAX_INFORMATION30
, PVAL107 P_ADDITIONAL_INFO1
, PVAL108 P_ADDITIONAL_INFO2
, PVAL109 P_ADDITIONAL_INFO3
, PVAL110 P_ADDITIONAL_INFO4
, PVAL111 P_ADDITIONAL_INFO5
, PVAL112 P_ADDITIONAL_INFO6
, PVAL113 P_ADDITIONAL_INFO7
, PVAL114 P_ADDITIONAL_INFO8
, PVAL115 P_ADDITIONAL_INFO9
, PVAL116 P_ADDITIONAL_INFO10 FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 3848 WITH CHECK OPTION