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_JP_ITAX_ARCHIVE_PKG dependencies on PAY_JP_WIC_ASSACTS_V

Line 186: -- pay_jp_wic_assacts_v for usability.

182: -- can be ignored because "exists" validation is performed only once for each ASSIGNMENT_ID.
183: --
184: -- Cursor is changed not to check archive data as follows.
185: -- Assignment action is created for each assignment returned by view
186: -- pay_jp_wic_assacts_v for usability.
187: -- It is recommended not to specify "Payroll" and "Withholding Agent"
188: -- parameters which will be confusing for user when archive is created
189: -- for inappropriate assact in the middle of the year.
190: -- "Assignment Set" will be the best solution.

Line 235: from pay_jp_wic_assacts_v wic

231: or
232: */
233: exists(
234: select null
235: from pay_jp_wic_assacts_v wic
236: where wic.assignment_id = asg.assignment_id
237: and wic.effective_date
238: between g_soy and g_effective_date
239: and ((g_itax_organization_id is null) or (wic.itax_organization_id = g_itax_organization_id))

Line 399: from pay_jp_wic_assacts_v wic,

395: wic.date_start,
396: wic.leaving_reason,
397: wic.actual_termination_date,
398: wic.employment_category
399: from pay_jp_wic_assacts_v wic,
400: pay_all_payrolls_f pay
401: where wic.assignment_id = cp_assignment_id
402: and wic.effective_date
403: between g_soy and g_effective_date