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_UPDATE_ADI_TAX_CRP

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_HIRE_DATE,
       pval002 P_LEGAL_EMPLOYER,
       pval003 P_TAX_FILE_NUMBER,
       pval004 P_TAX_FREE_THRESHOLD,
       pval005 P_AUSTRALIAN_RESIDENT,
       pval006 P_HECS,
       pval007 P_SFSS,
       pval008 P_LEAVE_LOADING,
       pval009 P_BASIS_OF_PAYMENT,
       pval010 P_DECLARATION_SIGNED_DATE,
       pval011 P_MEDICARE_LEVY_SURCHARGE,
       pval012 P_MEDICARE_LEVY_EXEMPTION,
       pval013 P_MEDICARE_LEVY_DEP_CHILDREN,
       pval014 P_MEDICARE_LEVY_SPOUSE,
       pval015 P_TAX_VARIATION_TYPE,
       pval016 P_TAX_VARIATION_AMOUNT,
       pval017 P_TAX_VARIATION_BONUS,
       pval018 P_REBATE_AMOUNT,
       pval019 P_SAVINGS_REBATE,
       pval020 P_FTB_CLAIM,
       pval021 P_SENIOR_AUSTRALIAN,
       pval022 P_EXEMPT_FLOOD_LEVY,
       pval023 P_MLS_RATE,
       pval024 P_EFFECTIVE_DATE,
       pval025 P_ASSIGNMENT_USER_KEY,
       pval026 P_PAYROLL_NAME
from hr_pump_batch_lines
where api_module_id = 3620
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_HIRE_DATE
, PVAL002 P_LEGAL_EMPLOYER
, PVAL003 P_TAX_FILE_NUMBER
, PVAL004 P_TAX_FREE_THRESHOLD
, PVAL005 P_AUSTRALIAN_RESIDENT
, PVAL006 P_HECS
, PVAL007 P_SFSS
, PVAL008 P_LEAVE_LOADING
, PVAL009 P_BASIS_OF_PAYMENT
, PVAL010 P_DECLARATION_SIGNED_DATE
, PVAL011 P_MEDICARE_LEVY_SURCHARGE
, PVAL012 P_MEDICARE_LEVY_EXEMPTION
, PVAL013 P_MEDICARE_LEVY_DEP_CHILDREN
, PVAL014 P_MEDICARE_LEVY_SPOUSE
, PVAL015 P_TAX_VARIATION_TYPE
, PVAL016 P_TAX_VARIATION_AMOUNT
, PVAL017 P_TAX_VARIATION_BONUS
, PVAL018 P_REBATE_AMOUNT
, PVAL019 P_SAVINGS_REBATE
, PVAL020 P_FTB_CLAIM
, PVAL021 P_SENIOR_AUSTRALIAN
, PVAL022 P_EXEMPT_FLOOD_LEVY
, PVAL023 P_MLS_RATE
, PVAL024 P_EFFECTIVE_DATE
, PVAL025 P_ASSIGNMENT_USER_KEY
, PVAL026 P_PAYROLL_NAME FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 3620 WITH CHECK OPTION