DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on DUAL

Line 249: FROM DUAL;

245:
246: CURSOR local_w2_xml_curr_act_id IS
247: SELECT 'TRANSFER_ACT_ID=P',
248: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
249: FROM DUAL;
250:
251: CURSOR GET_XML_VER IS
252: SELECT 'ROOT_XML_TAG=P',
253: '',

Line 257: FROM dual;

253: '',
254: 'PAYROLL_ACTION_ID=P',
255: pay_magtape_generic.get_parameter_value(
256: 'TRANSFER_PAYROLL_ACTION_ID')
257: FROM dual;
258:
259: FUNCTION bal_db_item
260: (
261: p_db_item_name VARCHAR2

Line 305: FROM DUAL;

301:
302: CURSOR LOCAL_CURR_ACT_ID IS
303: SELECT 'TRANSFER_ACT_ID=P',
304: pay_magtape_generic.get_parameter_value( 'TRANSFER_ACT_ID' )
305: FROM DUAL;
306:
307: CURSOR LOCAL_MAG_ASG_ACT IS
308: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
309: FROM pay_assignment_actions paa