eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_EFT dependencies on PAY_MAGTAPE_GENERIC

Line 56: , pay_magtape_generic.get_parameter_value('TRANSACTION_DATE')

52: cursor c_ibg_control is
53: Select 'RECORD_TYPE=P'
54: , '0'
55: , 'VALUE_DATE=P'
56: , pay_magtape_generic.get_parameter_value('TRANSACTION_DATE')
57: , 'O_BANK_NO=P'
58: , decode(sign((ses.effective_date)
59: - to_date('31/12/2001','dd/mm/yyyy')-1),-1,hrl.meaning,decode(lookup_code,'POSB',7171,hrl.meaning))/*bug2843503*/
60: , 'O_BRANCH_NO=P'

Line 87: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

83: , pay_payroll_actions ppa
84: , hr_organization_units o
85: , hr_lookups hrl
86: where ppa.payroll_action_id =
87: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
88: and oea.external_account_id = popm.external_account_id
89: and session_id = userenv('sessionid')
90: and ppa.business_group_id = o.organization_id
91: and hrl.lookup_code = oea.segment4

Line 142: , NVL(pay_magtape_generic.get_parameter_value('TRANSACTION_CODE'),'22')

138: replace(pea.segment1,'-',null))
139: , 'R_ACCOUNT_NAME=P'
140: , substr(pea.segment2,1,20)
141: , 'TRAN_CODE=P'
142: , NVL(pay_magtape_generic.get_parameter_value('TRANSACTION_CODE'),'22')
143: , 'PAY_AMOUNT=P'
144: , to_char(NVL(ppp.value,0)*100) a_amount
145: , 'NRIC=P'
146: , nvl(substr(p.national_identifier,1,9),' ')

Line 168: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

164: , hr_lookups hrl
165: , fnd_sessions ses
166: where
167: paa.payroll_action_id =
168: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
169: and ppa.payroll_action_id =
170: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') /* Bug#5749324 */
171: and ses.session_id = userenv('sessionid')
172: and ppp.pre_payment_id = paa.pre_payment_id

Line 170: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') /* Bug#5749324 */

166: where
167: paa.payroll_action_id =
168: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
169: and ppa.payroll_action_id =
170: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') /* Bug#5749324 */
171: and ses.session_id = userenv('sessionid')
172: and ppp.pre_payment_id = paa.pre_payment_id
173: and paa.payroll_action_id = ppa.payroll_action_id
174: and oea.external_account_id = popm.external_account_id

Line 183: and o.name = pay_magtape_generic.get_parameter_value('ORG_NAME')

179: and a.person_id = p.person_id
180: and a.business_group_id = o.organization_id
181: and hrl.lookup_code = pea.segment4
182: and hrl.lookup_type = 'SG_BANK_CODE'
183: and o.name = pay_magtape_generic.get_parameter_value('ORG_NAME')
184: and popm.org_payment_method_name = pay_magtape_generic.get_parameter_value('PAY_METHOD')
185: and ppa.effective_date between pppm.effective_start_date and pppm.effective_end_date
186: and ppa.effective_date between a.effective_start_date and a.effective_end_date
187: and ppa.effective_date between p.effective_start_date and p.effective_end_date

Line 184: and popm.org_payment_method_name = pay_magtape_generic.get_parameter_value('PAY_METHOD')

180: and a.business_group_id = o.organization_id
181: and hrl.lookup_code = pea.segment4
182: and hrl.lookup_type = 'SG_BANK_CODE'
183: and o.name = pay_magtape_generic.get_parameter_value('ORG_NAME')
184: and popm.org_payment_method_name = pay_magtape_generic.get_parameter_value('PAY_METHOD')
185: and ppa.effective_date between pppm.effective_start_date and pppm.effective_end_date
186: and ppa.effective_date between a.effective_start_date and a.effective_end_date
187: and ppa.effective_date between p.effective_start_date and p.effective_end_date
188: and ppa.effective_date between popm.effective_start_date and popm.effective_end_date /* Bug : 2788865 */