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.

[Home] [Help]

View: PAY_JP_INPUT_VALUE_IDS_V

Product:	PAY - Payroll
Description:	This view is used in Japanese localization.
Implementation/DBA Data:	APPS.PAY_JP_INPUT_VALUE_IDS_V

View Text

SELECT PBG.BUSINESS_GROUP_ID
, PAY_JP_BALANCE_PKG.GET_INPUT_VALUE_ID('COM_HI_QUALIFY_INFO'
, 'QUALIFY_DATE'
, PBG.BUSINESS_GROUP_ID
, PBG.LEGISLATION_CODE)
, PAY_JP_BALANCE_PKG.GET_INPUT_VALUE_ID('COM_HI_QUALIFY_INFO'
, 'DISQUALIFY_DATE'
, PBG.BUSINESS_GROUP_ID
, PBG.LEGISLATION_CODE)
, PAY_JP_BALANCE_PKG.GET_INPUT_VALUE_ID('COM_SI_INFO'
, 'HI_LOCATION'
, PBG.BUSINESS_GROUP_ID
, PBG.LEGISLATION_CODE)
, PAY_JP_BALANCE_PKG.GET_INPUT_VALUE_ID('COM_WP_QUALIFY_INFO'
, 'QUALIFY_DATE'
, PBG.BUSINESS_GROUP_ID
, PBG.LEGISLATION_CODE)
, PAY_JP_BALANCE_PKG.GET_INPUT_VALUE_ID('COM_WP_QUALIFY_INFO'
, 'DISQUALIFY_DATE'
, PBG.BUSINESS_GROUP_ID
, PBG.LEGISLATION_CODE)
, PAY_JP_BALANCE_PKG.GET_INPUT_VALUE_ID('COM_SI_INFO'
, 'WP_LOCATION'
, PBG.BUSINESS_GROUP_ID
, PBG.LEGISLATION_CODE)
, PAY_JP_BALANCE_PKG.GET_INPUT_VALUE_ID('COM_SI_REPORT_INFO'
, 'OUTPUT_FLAG'
, PBG.BUSINESS_GROUP_ID
, PBG.LEGISLATION_CODE)
FROM PER_BUSINESS_GROUPS PBG

Columns

Name
BUSINESS_GROUP_ID
HI_QUALIFIED_DATE_IV_ID
HI_DISQUALIFIED_DATE_IV_ID
HI_ORGANIZATION_IV_ID
WP_QUALIFIED_DATE_IV_ID
WP_DISQUALIFIED_DATE_IV_ID
WP_ORGANIZATION_IV_ID
OUTPUT_FLAG_IV_ID