DBA Data[Home] [Help]

APPS.PAY_WAT_UDFS dependencies on PAY_ELEMENT_TYPES_F

Line 25: FROM pay_element_types_f pet,

21: l_cat varchar2(20);
22: begin
23: SELECT pet.element_information1
24: INTO l_cat
25: FROM pay_element_types_f pet,
26: pay_element_links_f pel,
27: pay_element_entries_f PEE
28: WHERE PEE.element_entry_id = p_ele_entry_id
29: AND p_date_earned

Line 276: PAY_ELEMENT_TYPES_F pet

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
280: AND target.effective_end_date