DBA Data[Home] [Help]

APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on HR_ORGANIZATION_INFORMATION

Line 104: from HR_ORGANIZATION_INFORMATION hoi

100:
101: cursor us_mws_worksite_organization is
102: select 'ORGANIZATION_ID=C', hoi.organization_id,
103: 'ORGANIZATION_ID=P', hoi.organization_id
104: from HR_ORGANIZATION_INFORMATION hoi
105: where hoi.org_information_context = 'Worksite Filing'
106: and hoi.org_information3 is not null
107: and hoi.org_information2 = pay_magtape_generic.get_parameter_value
108: ('TRANSFER_SUI_ACCOUNT_NO')