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_AU_PAYMENT_SUMMARY_MAGTAPE dependencies on FF_ARCHIVE_ITEMS

Line 101: ff_archive_items ff,

97: -- ,decode(fue.user_entity_name,'X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD',decode(value ,0,null ,null,null, 'P')) etp_payer_type
98: from
99: pay_assignment_actions ppac,
100: pay_payroll_actions ppa,
101: ff_archive_items ff,
102: ff_user_entities fue
103: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
104: and ppac.action_status='C'
105: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)

Line 137: ff_archive_items ff,

133: pay_assignment_actions ppac, --self printed
134: pay_action_interlocks ppai,
135: pay_assignment_actions apac, --archive
136: pay_payroll_actions ppa, --self printed
137: ff_archive_items ff,
138: ff_user_entities fue
139: where mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
140: and mpac.action_status ='C'
141: and ppac.action_status='C'

Line 179: from ff_user_entities fue, ff_archive_items ff

175: and mpa.report_qualifier = 'AU'
176: and mpa.report_category = 'REPORT'
177: /* Added check for bug 5353402 - Details will be displayed in the Data File only if sum of values of these balances are greater than zero */
178: and 1 <= (select sum(nvl(value,0))
179: from ff_user_entities fue, ff_archive_items ff
180: where fue.user_Entity_id = ff.user_entity_id
181: and fue.user_entity_name in
182: ('X_ALLOWANCE_1_ASG_YTD','X_ALLOWANCE_2_ASG_YTD','X_ALLOWANCE_3_ASG_YTD',
183: 'X_ALLOWANCE_4_ASG_YTD','X_FRINGE_BENEFITS_ASG_YTD',

Line 221: from ff_user_entities fue, ff_archive_items ff

217: and apac.assignment_id = ppac.assignment_id /* 5471093 */
218: and ppac.assignment_id = mpac.assignment_id /* 5471093 */
219: /* Added check for bug 5353402 - Details will be displayed in the Data File only if sum of values of these balances are greater than zero */
220: and 1 <= (select sum(nvl(value,0))
221: from ff_user_entities fue, ff_archive_items ff
222: where fue.user_Entity_id = ff.user_entity_id
223: and fue.user_entity_name in
224: ('X_ALLOWANCE_1_ASG_YTD','X_ALLOWANCE_2_ASG_YTD','X_ALLOWANCE_3_ASG_YTD',
225: 'X_ALLOWANCE_4_ASG_YTD','X_FRINGE_BENEFITS_ASG_YTD',

Line 262: from ff_user_entities fue, ff_archive_items ff

258: and mpa.report_type = 'AU_PS_DATA_FILE_VAL'
259: and mpa.report_qualifier = 'AU'
260: and mpa.report_category = 'REPORT'
261: and 1 <= (select sum(nvl(value,0))
262: from ff_user_entities fue, ff_archive_items ff
263: where fue.user_Entity_id = ff.user_entity_id
264: and fue.user_entity_name in
265: ('X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD',
266: 'X_PRE_JUL_83_COMPONENT_ASG_YTD',

Line 300: from ff_user_entities fue, ff_archive_items ff

296: and ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
297: and apac.assignment_id = ppac.assignment_id
298: and ppac.assignment_id = mpac.assignment_id
299: and 1 <= (select sum(nvl(value,0))
300: from ff_user_entities fue, ff_archive_items ff
301: where fue.user_Entity_id = ff.user_entity_id
302: and fue.user_entity_name in
303: ('X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD',
304: 'X_PRE_JUL_83_COMPONENT_ASG_YTD',