DBA Data[Home] [Help]

APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on PAY_STATE_RULES

Line 46: PAY_STATE_RULES psr

42: cursor us_mws_state is
43: select distinct 'TRANSFER_MWS_STATE=P', hwv.mws_state ,
44: 'TRANSFER_FIPS_CODE=P', psr.fips_code
45: from HR_WORKSITE_V hwv,
46: PAY_STATE_RULES psr
47: where hwv.mws_business_group_id = pay_magtape_generic.get_parameter_value
48: ('TRANSFER_BUSINESS_GROUP')
49: and psr.state_code = hwv.mws_state
50: order by hwv.mws_state;