APPS.PAY_CA_RL1_CAN_MAG dependencies on PAY_ACTION_INFORMATION

Line 312: from pay_action_information pai

308: and fdi.user_name LIKE 'CAEOY_RL1_FURTHER_INFO_AMOUNT_%_AMT_PER_JD_YTD'
309: union
310: select 'G-1' code,
311: pai.action_information5 value
312: from pay_action_information pai
313: where pai.action_context_id = p_arch_assact_id
314: and pai.action_information4 = 'G-1'
315: ) order by code;
316:

Line 1316: from pay_action_information pai

1312: and fdi.user_name LIKE 'CAEOY_RL1_FURTHER_INFO_AMOUNT_%_AMT_PER_JD_YTD'
1313: union
1314: select 'G-1' code,
1315: to_number(pai.action_information5) value
1316: from pay_action_information pai
1317: where pai.action_context_id = p_arch_assact_id
1318: and pai.action_information4 = 'G-1'
1319: ) order by code;
1320: /* ended these CURSORs for bug 13360884, to get further information*/