DBA Data[Home] [Help]

APPS.PAY_MX_ISR_FORMAT37_INFO dependencies on DUAL

Line 13: FROM sys.dual;

9: RETURN CLOB;
10:
11: CURSOR main_block IS
12: SELECT 'Version_Number=X' ,'Version 1.1'
13: FROM sys.dual;
14:
15: CURSOR Transfer_Block IS
16: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
17: FROM pay_assignment_actions paa

Line 26: FROM DUAL;

22: CURSOR c_get_asg_action IS
23: SELECT 'TRANSFER_ACT_ID=P',
24: pay_magtape_generic.get_parameter_value(
25: 'TRANSFER_ACT_ID')
26: FROM DUAL;
27:
28: PROCEDURE get_headers ;
29: PROCEDURE get_footers;
30: PROCEDURE fetch_format37_xml;