VIEW: APPS.HRDPV_UPDATE_CA_EMP_FEDTAX_INF

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_EFFECTIVE_START_DATE,
       pval002 P_EFFECTIVE_END_DATE,
       pval003 P_LEGISLATION_CODE,
       pval004 P_ASSIGNMENT_ID,
       pval005 P_EMPLOYMENT_PROVINCE,
       pval006 P_TAX_CREDIT_AMOUNT,
       pval007 P_CLAIM_CODE,
       pval008 P_BASIC_EXEMPTION_FLAG,
       pval009 P_ADDITIONAL_TAX,
       pval010 P_ANNUAL_DEDN,
       pval011 P_TOTAL_EXPENSE_BY_COMMISSION,
       pval012 P_TOTAL_REMNRTN_BY_COMMISSION,
       pval013 P_PRESCRIBED_ZONE_DEDN_AMT,
       pval014 P_OTHER_FEDTAX_CREDITS,
       pval015 P_CPP_QPP_EXEMPT_FLAG,
       pval016 P_FED_EXEMPT_FLAG,
       pval017 P_EI_EXEMPT_FLAG,
       pval018 P_TAX_CALC_METHOD,
       pval019 P_FED_OVERRIDE_AMOUNT,
       pval020 P_FED_OVERRIDE_RATE,
       pval021 P_CA_TAX_INFORMATION_CATEGORY,
       pval022 P_CA_TAX_INFORMATION1,
       pval023 P_CA_TAX_INFORMATION2,
       pval024 P_CA_TAX_INFORMATION3,
       pval025 P_CA_TAX_INFORMATION4,
       pval026 P_CA_TAX_INFORMATION5,
       pval027 P_CA_TAX_INFORMATION6,
       pval028 P_CA_TAX_INFORMATION7,
       pval029 P_CA_TAX_INFORMATION8,
       pval030 P_CA_TAX_INFORMATION9,
       pval031 P_CA_TAX_INFORMATION10,
       pval032 P_CA_TAX_INFORMATION11,
       pval033 P_CA_TAX_INFORMATION12,
       pval034 P_CA_TAX_INFORMATION13,
       pval035 P_CA_TAX_INFORMATION14,
       pval036 P_CA_TAX_INFORMATION15,
       pval037 P_CA_TAX_INFORMATION16,
       pval038 P_CA_TAX_INFORMATION17,
       pval039 P_CA_TAX_INFORMATION18,
       pval040 P_CA_TAX_INFORMATION19,
       pval041 P_CA_TAX_INFORMATION20,
       pval042 P_CA_TAX_INFORMATION21,
       pval043 P_CA_TAX_INFORMATION22,
       pval044 P_CA_TAX_INFORMATION23,
       pval045 P_CA_TAX_INFORMATION24,
       pval046 P_CA_TAX_INFORMATION25,
       pval047 P_CA_TAX_INFORMATION26,
       pval048 P_CA_TAX_INFORMATION27,
       pval049 P_CA_TAX_INFORMATION28,
       pval050 P_CA_TAX_INFORMATION29,
       pval051 P_CA_TAX_INFORMATION30,
       pval052 P_FED_LSF_AMOUNT,
       pval053 P_CPP_ELECTION_DATE,
       pval054 P_CPP_REVOCATION_DATE,
       pval055 P_EFFECTIVE_DATE,
       pval056 P_DATETRACK_MODE,
       pval057 P_EMP_FED_TAX_INF_USER_KEY
from hr_pump_batch_lines
where api_module_id = 1158
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_EFFECTIVE_START_DATE
, PVAL002 P_EFFECTIVE_END_DATE
, PVAL003 P_LEGISLATION_CODE
, PVAL004 P_ASSIGNMENT_ID
, PVAL005 P_EMPLOYMENT_PROVINCE
, PVAL006 P_TAX_CREDIT_AMOUNT
, PVAL007 P_CLAIM_CODE
, PVAL008 P_BASIC_EXEMPTION_FLAG
, PVAL009 P_ADDITIONAL_TAX
, PVAL010 P_ANNUAL_DEDN
, PVAL011 P_TOTAL_EXPENSE_BY_COMMISSION
, PVAL012 P_TOTAL_REMNRTN_BY_COMMISSION
, PVAL013 P_PRESCRIBED_ZONE_DEDN_AMT
, PVAL014 P_OTHER_FEDTAX_CREDITS
, PVAL015 P_CPP_QPP_EXEMPT_FLAG
, PVAL016 P_FED_EXEMPT_FLAG
, PVAL017 P_EI_EXEMPT_FLAG
, PVAL018 P_TAX_CALC_METHOD
, PVAL019 P_FED_OVERRIDE_AMOUNT
, PVAL020 P_FED_OVERRIDE_RATE
, PVAL021 P_CA_TAX_INFORMATION_CATEGORY
, PVAL022 P_CA_TAX_INFORMATION1
, PVAL023 P_CA_TAX_INFORMATION2
, PVAL024 P_CA_TAX_INFORMATION3
, PVAL025 P_CA_TAX_INFORMATION4
, PVAL026 P_CA_TAX_INFORMATION5
, PVAL027 P_CA_TAX_INFORMATION6
, PVAL028 P_CA_TAX_INFORMATION7
, PVAL029 P_CA_TAX_INFORMATION8
, PVAL030 P_CA_TAX_INFORMATION9
, PVAL031 P_CA_TAX_INFORMATION10
, PVAL032 P_CA_TAX_INFORMATION11
, PVAL033 P_CA_TAX_INFORMATION12
, PVAL034 P_CA_TAX_INFORMATION13
, PVAL035 P_CA_TAX_INFORMATION14
, PVAL036 P_CA_TAX_INFORMATION15
, PVAL037 P_CA_TAX_INFORMATION16
, PVAL038 P_CA_TAX_INFORMATION17
, PVAL039 P_CA_TAX_INFORMATION18
, PVAL040 P_CA_TAX_INFORMATION19
, PVAL041 P_CA_TAX_INFORMATION20
, PVAL042 P_CA_TAX_INFORMATION21
, PVAL043 P_CA_TAX_INFORMATION22
, PVAL044 P_CA_TAX_INFORMATION23
, PVAL045 P_CA_TAX_INFORMATION24
, PVAL046 P_CA_TAX_INFORMATION25
, PVAL047 P_CA_TAX_INFORMATION26
, PVAL048 P_CA_TAX_INFORMATION27
, PVAL049 P_CA_TAX_INFORMATION28
, PVAL050 P_CA_TAX_INFORMATION29
, PVAL051 P_CA_TAX_INFORMATION30
, PVAL052 P_FED_LSF_AMOUNT
, PVAL053 P_CPP_ELECTION_DATE
, PVAL054 P_CPP_REVOCATION_DATE
, PVAL055 P_EFFECTIVE_DATE
, PVAL056 P_DATETRACK_MODE
, PVAL057 P_EMP_FED_TAX_INF_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 1158 WITH CHECK OPTION