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.

APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on PAY_MAGTAPE_GENERIC

Line 33: where htv.tax_unit_id = pay_magtape_generic.get_parameter_value

29: 'TRANSFER_TAPE_MEDIUM=P', htv.mws_tape_medium,
30: 'TRANSFER_TAPE_DENSITY=P', htv.mws_tape_density,
31: 'TRANSFER_HEADER_LABEL=P', htv.mws_header_label
32: from hr_tax_units_v htv
33: where htv.tax_unit_id = pay_magtape_generic.get_parameter_value
34: ('TRANSFER_TRANS_LEGAL_CO_ID')
35: and htv.business_group_id = pay_magtape_generic.get_parameter_value
36: ('TRANSFER_BUSINESS_GROUP');
37:

Line 35: and htv.business_group_id = pay_magtape_generic.get_parameter_value

31: 'TRANSFER_HEADER_LABEL=P', htv.mws_header_label
32: from hr_tax_units_v htv
33: where htv.tax_unit_id = pay_magtape_generic.get_parameter_value
34: ('TRANSFER_TRANS_LEGAL_CO_ID')
35: and htv.business_group_id = pay_magtape_generic.get_parameter_value
36: ('TRANSFER_BUSINESS_GROUP');
37:
38:
39: /* Sets up the State context for US_MWS_GET_STATE formula and the State

Line 47: where hwv.mws_business_group_id = pay_magtape_generic.get_parameter_value

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;
51:

Line 61: where hwv.mws_state = pay_magtape_generic.get_parameter_value

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')
65: order by hwv.mws_sui_account_no;

Line 63: and hwv.mws_business_group_id = pay_magtape_generic.get_parameter_value

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')
65: order by hwv.mws_sui_account_no;
66:
67:

Line 87: where hwv.mws_sui_account_no = pay_magtape_generic.get_parameter_value

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')
91: and hwv.mws_state = pay_magtape_generic.get_parameter_value

Line 89: and hwv.mws_tax_unit_id = pay_magtape_generic.get_parameter_value

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')
91: and hwv.mws_state = pay_magtape_generic.get_parameter_value
92: ('TRANSFER_MWS_STATE')
93: and hwv.mws_business_group_id = pay_magtape_generic.get_parameter_value

Line 91: and hwv.mws_state = pay_magtape_generic.get_parameter_value

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')
91: and hwv.mws_state = pay_magtape_generic.get_parameter_value
92: ('TRANSFER_MWS_STATE')
93: and hwv.mws_business_group_id = pay_magtape_generic.get_parameter_value
94: ('TRANSFER_BUSINESS_GROUP')
95: order by hwv.mws_reporting_unit_no;

Line 93: and hwv.mws_business_group_id = pay_magtape_generic.get_parameter_value

89: and hwv.mws_tax_unit_id = pay_magtape_generic.get_parameter_value
90: ('MWS_TAX_UNIT_ID')
91: and hwv.mws_state = pay_magtape_generic.get_parameter_value
92: ('TRANSFER_MWS_STATE')
93: and hwv.mws_business_group_id = pay_magtape_generic.get_parameter_value
94: ('TRANSFER_BUSINESS_GROUP')
95: order by hwv.mws_reporting_unit_no;
96:
97:

Line 107: and hoi.org_information2 = pay_magtape_generic.get_parameter_value

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')
109: and hoi.org_information3 = pay_magtape_generic.get_parameter_value
110: ('TRANSFER_WORKSITE_RUN')
111: order by hoi.organization_id;

Line 109: and hoi.org_information3 = pay_magtape_generic.get_parameter_value

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')
109: and hoi.org_information3 = pay_magtape_generic.get_parameter_value
110: ('TRANSFER_WORKSITE_RUN')
111: order by hoi.organization_id;
112:
113:

Line 130: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value

126: PAY_ASSIGNMENT_ACTIONS paa,
127: PER_ASSIGNMENTS_F paf,
128: PER_PEOPLE_F ppf,
129: HR_SOFT_CODING_KEYFLEX scl
130: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
131: ('TRANSFER_PAYROLL_ACTION_ID')
132: and paa.payroll_action_id = ppa.payroll_action_id
133: and paf.assignment_id = paa.assignment_id
134: and paf.organization_id = pay_magtape_generic.get_parameter_value

Line 134: and paf.organization_id = pay_magtape_generic.get_parameter_value

130: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
131: ('TRANSFER_PAYROLL_ACTION_ID')
132: and paa.payroll_action_id = ppa.payroll_action_id
133: and paf.assignment_id = paa.assignment_id
134: and paf.organization_id = pay_magtape_generic.get_parameter_value
135: ('ORGANIZATION_ID')
136: and paf.effective_end_date = to_date((substr(paa.serial_number,21,10)),
137: 'DD-MM-YYYY')
138: and scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id