DBA Data[Home] [Help]

APPS.PAY_WAT_UDFS dependencies on PAY_US_GARN_LIMIT_RULES_F

Line 275: FROM PAY_US_GARN_LIMIT_RULES_F target,

271: END IF;
272:
273: SELECT target.max_withholding_duration_days
274: INTO ln_garn_limit_days
275: FROM PAY_US_GARN_LIMIT_RULES_F target,
276: PAY_ELEMENT_TYPES_F pet
277: WHERE target.state_code = SUBSTR(p_jursd_code,1,2)
278: AND target.garn_category = pet.element_information1
279: AND ld_garn_date BETWEEN target.effective_start_date