DBA Data[Home] [Help]

APPS.PAY_IE_PAYPATH_TAPE dependencies on DUAL

Line 15: FROM dual;

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

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

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

Line 158: from dual

154: ,'USER_NAME=P', 'null'
155: ,'USER_REFERNCE=P', 'null'
156: ,'ACC_CREDIT_NAME=P', 'null'
157: ,'FILE_FORMAT=P','null'
158: from dual
159: order by 1,2;
160:
161:
162: CURSOR CSR_PPH_CONTRA_RECORD