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_AE_EFT dependencies on PAY_AE_GENERAL

Line 130: ,to_char(fnd_date.canonical_to_date(pay_ae_general.get_parameter(

126: CURSOR CSR_AE_EFT_HEADER IS
127: SELECT 'CREATION_DATE=P'
128: ,to_char(ppa.effective_date, 'DDMMYYYY')
129: ,'PROCESS_DATE=P'
130: ,to_char(fnd_date.canonical_to_date(pay_ae_general.get_parameter(
131: ppa.legislative_parameters,
132: 'PROCESS_DATE')), 'DDMMYYYY')
133: ,'DATE_EARNED=C'
134: ,to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')

Line 144: ,pay_ae_general.get_count

140: ,ppa.payroll_id
141: ,'PAYROLL_ACTION_ID=C'
142: ,ppa.payroll_action_id
143: ,'COUNT1=P'
144: ,pay_ae_general.get_count
145: ,'SUMT=P'
146: ,nvl(to_char(pay_ae_general.get_total_sum * 100),'0')
147: ,'SUMC=P'
148: ,nvl(to_char(pay_ae_general.get_credit_sum * 100),'0')

Line 146: ,nvl(to_char(pay_ae_general.get_total_sum * 100),'0')

142: ,ppa.payroll_action_id
143: ,'COUNT1=P'
144: ,pay_ae_general.get_count
145: ,'SUMT=P'
146: ,nvl(to_char(pay_ae_general.get_total_sum * 100),'0')
147: ,'SUMC=P'
148: ,nvl(to_char(pay_ae_general.get_credit_sum * 100),'0')
149: ,'SUMD=P'
150: ,nvl(to_char(pay_ae_general.get_debit_sum * 100),'0')

Line 148: ,nvl(to_char(pay_ae_general.get_credit_sum * 100),'0')

144: ,pay_ae_general.get_count
145: ,'SUMT=P'
146: ,nvl(to_char(pay_ae_general.get_total_sum * 100),'0')
147: ,'SUMC=P'
148: ,nvl(to_char(pay_ae_general.get_credit_sum * 100),'0')
149: ,'SUMD=P'
150: ,nvl(to_char(pay_ae_general.get_debit_sum * 100),'0')
151: ,'TAPE_TYPE=P'
152: ,nvl(pay_ae_general.get_parameter(ppa.legislative_parameters,'TAPE_TYPE'),' ')

Line 150: ,nvl(to_char(pay_ae_general.get_debit_sum * 100),'0')

146: ,nvl(to_char(pay_ae_general.get_total_sum * 100),'0')
147: ,'SUMC=P'
148: ,nvl(to_char(pay_ae_general.get_credit_sum * 100),'0')
149: ,'SUMD=P'
150: ,nvl(to_char(pay_ae_general.get_debit_sum * 100),'0')
151: ,'TAPE_TYPE=P'
152: ,nvl(pay_ae_general.get_parameter(ppa.legislative_parameters,'TAPE_TYPE'),' ')
153: FROM pay_payroll_actions ppa
154: WHERE ppa.payroll_action_id =

Line 152: ,nvl(pay_ae_general.get_parameter(ppa.legislative_parameters,'TAPE_TYPE'),' ')

148: ,nvl(to_char(pay_ae_general.get_credit_sum * 100),'0')
149: ,'SUMD=P'
150: ,nvl(to_char(pay_ae_general.get_debit_sum * 100),'0')
151: ,'TAPE_TYPE=P'
152: ,nvl(pay_ae_general.get_parameter(ppa.legislative_parameters,'TAPE_TYPE'),' ')
153: FROM pay_payroll_actions ppa
154: WHERE ppa.payroll_action_id =
155: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
156: AND EXISTS (

Line 172: ,decode(pay_ae_general.chk_tran_code(ppp.value)

168: CURSOR CSR_AE_EFT_BODY IS
169: SELECT 'AMOUNT=P'
170: ,ppp.value * 100
171: ,'TRANCODE=P'
172: ,decode(pay_ae_general.chk_tran_code(ppp.value)
173: ,'Y','C'
174: ,'N', 'D')
175: ,'FIRST_NAME=P'
176: , substr(pef.full_name,1,40)

Line 184: ,decode(pay_ae_general.chk_multiple_assignments(ppa.effective_date,paf.person_id)

180: ,substr(pef.per_information1,1,35)
181: ,'EMP_NO=P'
182: , nvl(pef.employee_number,' ')
183: ,'ASG_NO=P'
184: ,decode(pay_ae_general.chk_multiple_assignments(ppa.effective_date,paf.person_id)
185: ,'Y',nvl(paf.assignment_number,' ')
186: ,'N', ' ')
187: ,'ASSIGNMENT_ID=C' , paf.assignment_id
188: ,'BUSINESS_GROUP_ID=C' , paf.business_group_id

Line 198: ,pay_ae_general.get_parameter(ppa.legislative_parameters,

194: ,'ASSIGNMENT_ACTION_ID=C', ppa.org_payment_method_id
195: ,'ORGANIZATION_ID=C' , paf.organization_id
196: ,'TAX_UNIT_ID=C' , paa.tax_unit_id
197: ,'LOCAL_NATIONALITY=P'
198: ,pay_ae_general.get_parameter(ppa.legislative_parameters,
199: 'LOCAL_NATIONALITY')
200: FROM per_assignments_f paf
201: ,per_people_f pef
202: ,pay_pre_payments ppp

Line 216: ORDER BY decode(pay_ae_general.get_parameter(legislative_parameters,

212: AND ppa.effective_date BETWEEN paf.effective_start_date
213: AND paf.effective_end_date
214: AND ppa.effective_date BETWEEN pef.effective_start_date
215: AND pef.effective_end_date
216: ORDER BY decode(pay_ae_general.get_parameter(legislative_parameters,
217: 'SORT_ORDER'),
218: 'NAME', substr(pef.last_name || ' ' || pef.first_name,1,50),
219: 'NUMBER', pef.employee_number, null);
220: END PAY_AE_EFT;