DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on PAY_JP_WIC_ASSACTS_V2

Line 254: from pay_jp_wic_assacts_v2

250: p_withholding_tax_info.si_prem,
251: p_withholding_tax_info.itax,
252: p_withholding_tax_info.itax_adjustment,
253: p_withholding_tax_info.disaster_tax_reduction
254: from pay_jp_wic_assacts_v2
255: where assignment_id = p_assignment_id
256: and action_sequence <= p_action_sequence
257: and effective_date >= trunc(p_effective_date, 'YYYY')
258: and itax_organization_id = p_itax_organization_id;

Line 277: from pay_jp_wic_assacts_v2

273: p_withholding_tax_info.si_prem,
274: p_withholding_tax_info.itax,
275: p_withholding_tax_info.itax_adjustment,
276: p_withholding_tax_info.disaster_tax_reduction
277: from pay_jp_wic_assacts_v2
278: where assignment_id = p_assignment_id
279: and action_sequence <= p_action_sequence
280: and effective_date >= trunc(p_effective_date, 'YYYY')
281: and (

Line 3913: pay_jp_wic_assacts_v2 wic

3909: from per_all_people_f per,
3910: hr_organization_information hoi,
3911: pay_all_payrolls_f pay,
3912: /* Use V2 instead of V for debugging. */
3913: pay_jp_wic_assacts_v2 wic
3914: where wic.assignment_action_id = p_assignment_action_id
3915: and pay.payroll_id = wic.payroll_id
3916: and wic.date_earned
3917: between pay.effective_start_date and pay.effective_end_date