VIEW: APPS.PAY_JP_INPUT_VALUE_IDS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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