APPS.PAY_IE_PAYPATH_TAPE dependencies on DUAL

Line 19: FROM dual;

15: /*Bug no. 3813140*/
16: CURSOR CSR_PPH_HEADER
17: IS
18: SELECT 'DUMMY=P' , '1' --pay_ie_paypath_tape.get_paypathid pathid
19: FROM dual;
20:
21: CURSOR CSR_PPH_HEADER_RECORD
22: IS
23: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,

Line 54: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464

50: , pay_external_accounts pea
51: , hr_organization_units hou
52: , hr_organization_information org
53:
54: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464
55: where
56: ppa.payroll_action_id = -- Bug No 3513042
57: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
58: and paa.payroll_action_id = ppa.payroll_action_id

Line 162: from dual

158: ,'USER_NAME=P', 'null'
159: ,'USER_REFERNCE=P', 'null'
160: ,'ACC_CREDIT_NAME=P', 'null'
161: ,'FILE_FORMAT=P','null'
162: from dual
163: order by 1,2;
164:
165:
166: CURSOR CSR_PPH_CONTRA_RECORD

Line 276: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464

272: , pay_external_accounts pea
273: , hr_organization_units hou
274: , hr_organization_information org
275:
276: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464
277: where
278: ppa.payroll_action_id = -- Bug No 3513042
279: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
280: and paa.payroll_action_id = ppa.payroll_action_id

Line 384: from dual

380: ,'USER_NAME=P', 'null'
381: ,'USER_REFERNCE=P', 'null'
382: ,'ACC_CREDIT_NAME=P', 'null'
383: ,'FILE_FORMAT=P','null'
384: from dual
385: order by 1,2;
386:
387: CURSOR CSR_BPH_CONTRA_RECORD
388: IS