DBA Data[Home] [Help]

APPS.PAY_CA_RL1_MAG dependencies on PAY_ACTION_INFORMATION

Line 4437: from pay_action_information pai

4433: AND HL.LOOKUP_CODE = SUBSTR(replace(FDI.USER_NAME,'_AMT_PER_JD_YTD'),-2)
4434: union all
4435: select pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
4436: to_number(pai.action_information5) value
4437: from pay_action_information pai
4438: , hr_lookups hl
4439: where pai.action_context_id = p_arch_assactid
4440: and hl.lookup_type = 'PAY_CA_RL1_NONBOX_FOOTNOTES'
4441: and hl.lookup_code = pai.action_information4