APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on HR_WORKSITE_V

Line 45: from HR_WORKSITE_V hwv,

41:
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

Line 60: from HR_WORKSITE_V hwv

56: cursor us_mws_sui is
57: select distinct 'TRANSFER_SUI_ACCOUNT_NO=P', hwv.mws_sui_account_no,
58: 'MWS_TAX_UNIT_ID=P', hwv.mws_tax_unit_id,
59: 'TAX_UNIT_ID=C', hwv.mws_tax_unit_id
60: from HR_WORKSITE_V hwv
61: where hwv.mws_state = pay_magtape_generic.get_parameter_value
62: ('TRANSFER_MWS_STATE')
63: and hwv.mws_business_group_id = pay_magtape_generic.get_parameter_value
64: ('TRANSFER_BUSINESS_GROUP')

Line 86: from HR_WORKSITE_V hwv

82: 'TRANSFER_WORKSITE_ADDRESS_LINE_3=P', hwv.mws_address_line_3,
83: 'TRANSFER_WORKSITE_CITY=P', hwv.mws_city,
84: 'TRANSFER_WORKSITE_STATE=P', hwv.mws_state,
85: 'TRANSFER_WORKSITE_ZIP_CODE=P', hwv.mws_zip_code
86: from HR_WORKSITE_V hwv
87: where hwv.mws_sui_account_no = pay_magtape_generic.get_parameter_value
88: ('TRANSFER_SUI_ACCOUNT_NO')
89: and hwv.mws_tax_unit_id = pay_magtape_generic.get_parameter_value
90: ('MWS_TAX_UNIT_ID')