DBA Data[Home] [Help]

APPS.PAY_US_MAGW2_REPORTING dependencies on DUAL

Line 359: FROM dual

355: substr(PMV.jurisdiction_code,1,2) = pus.state_code AND
356: pus.state_abbrev = 'OH'
357: AND (EXISTS(
358: SELECT 'y'
359: FROM dual
360: where hr_us_w2_rep.get_w2_arch_bal(aa.assignment_action_id,'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD',
361: aa.tax_unit_id,pmv.jurisdiction_code,8) > 0))
362: UNION ALL
363: SELECT 'ASSIGNMENT_ACTION_ID=C', AA.assignment_action_id,

Line 385: FROM dual

381: substr(PMC.jurisdiction_code,1,2) = PUS.state_code AND
382: PUS.state_abbrev = 'OH'
383: AND (EXISTS(
384: SELECT 'y'
385: FROM dual
386: where hr_us_w2_rep.get_w2_arch_bal(aa.assignment_action_id,'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD',
387: aa.tax_unit_id,pmc.jurisdiction_code,8) > 0))
388: UNION ALL
389: SELECT 'ASSIGNMENT_ACTION_ID=C', AA.assignment_action_id,