APPS.PAY_CA_RL1_MAG dependencies on PAY_ACTION_INFORMATION

Line 119: from pay_action_information pai

115: and fdi.user_name LIKE 'CAEOY_RL1_FURTHER_INFO_AMOUNT_%_AMT_PER_JD_YTD'
116: union
117: select 'G-1' code,
118: pai.action_information5 value
119: from pay_action_information pai
120: where pai.action_context_id = p_arch_assact_id
121: and pai.action_information4 = 'G-1'
122: ) order by code;
123:

Line 4476: from pay_action_information pai

4472: AND HL.LOOKUP_CODE = SUBSTR(replace(FDI.USER_NAME,'_AMT_PER_JD_YTD'),-2)
4473: union all
4474: select pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
4475: to_number(pai.action_information5) value
4476: from pay_action_information pai
4477: , hr_lookups hl
4478: where pai.action_context_id = p_arch_assactid
4479: and hl.lookup_type = 'PAY_CA_RL1_NONBOX_FOOTNOTES'
4480: and hl.lookup_code = pai.action_information4