DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on HR_LOCATIONS

Line 320: ,hr_locations hl

316: pus.state_abbrev
317: FROM ff_archive_items fai
318: ,ff_user_entities ue
319: ,pay_us_states pus
320: ,hr_locations hl
321: where fai.user_entity_id = ue.user_entity_id
322: and fai.context1 = to_char(p_ass_act_id) -- context of assignment action id
323: and ue.user_entity_name =
324: decode(p_mon_of_qtr,4,'A_SQWL_LOC_QTR_END','A_SQWL_LOC_MON_' || to_char(p_mon_of_qtr))