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_IE_PAYFILE_SEPA dependencies on PAY_MAGTAPE_GENERIC

Line 56: ,'CREATION_DATE=P', to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD"T"HH24:MI:SS')

52: CURSOR CSR_IE_HDR_FTR IS
53: SELECT DISTINCT 'TRANSFER_PARA_PMNT1=P',NULL
54: --To print the closing tag correctlty in case of multiple Employers.
55: --,'CREATION_DATE=P', to_char(ppa.effective_date, 'RRRR-MM-DD"T"HH24:MI:SS')
56: ,'CREATION_DATE=P', to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD"T"HH24:MI:SS')
57: ,'PROCESS_DATE=P' ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')
58: ,'BATCH_BOOKING=P',decode(pay_ie_payfile_sepa.get_parameter(ppa.legislative_parameters,'BATCH_BOOKING'),'Y','TRUE','N','FALSE','TRUE')
59: ,'TRANSFER_ORG_PAY_METHOD_ID=P',to_char(ppa.org_payment_method_id)
60: ,'DATE_EARNED=C',to_char(ppa.effective_date, 'RRRR/MM/DD HH24:MI:SS')

Line 57: ,'PROCESS_DATE=P' ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')

53: SELECT DISTINCT 'TRANSFER_PARA_PMNT1=P',NULL
54: --To print the closing tag correctlty in case of multiple Employers.
55: --,'CREATION_DATE=P', to_char(ppa.effective_date, 'RRRR-MM-DD"T"HH24:MI:SS')
56: ,'CREATION_DATE=P', to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD"T"HH24:MI:SS')
57: ,'PROCESS_DATE=P' ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')
58: ,'BATCH_BOOKING=P',decode(pay_ie_payfile_sepa.get_parameter(ppa.legislative_parameters,'BATCH_BOOKING'),'Y','TRUE','N','FALSE','TRUE')
59: ,'TRANSFER_ORG_PAY_METHOD_ID=P',to_char(ppa.org_payment_method_id)
60: ,'DATE_EARNED=C',to_char(ppa.effective_date, 'RRRR/MM/DD HH24:MI:SS')
61: ,'ORG_PAY_METHOD_ID=C',ppa.org_payment_method_id

Line 76: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

72: FROM pay_payroll_actions ppa
73: ,pay_org_payment_methods_f popmf --15971893
74: ,hr_all_organization_units hou --15971893
75: WHERE ppa.payroll_action_id =
76: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
77: AND ppa.org_payment_method_id = popmf.org_payment_method_id --15971893
78: AND hou.business_group_id = ppa.business_group_id --15971893
79: AND hou.organization_id = ppa.business_group_id --15971893
80: AND EXISTS (SELECT 1

Line 93: ,'REQ_EXEC_DATE=P',to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')

89: ********************************************************/
90: CURSOR CSR_IE_PMNT_INFO IS
91: SELECT distinct 'PARA_PMNT1=P' ,to_char(pea.external_account_id)
92: --To print the closing tag correctlty in case of multiple Employers.
93: ,'REQ_EXEC_DATE=P',to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')
94: ,'DBTR_NAME=P',hou.name
95: ,'TRANSFER_ORGANIZATION_ID=P',to_char(hou.organization_id)
96: ,'EXTERNAL_ACCOUNT_ID=P',to_char(pea.external_account_id)
97: ,'IBAN=P',NVL(pea.SEGMENT7,' ')

Line 113: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

109: PAY_EXTERNAL_ACCOUNTS pea,
110: PAY_PAYROLL_ACTIONS ppa,
111: pay_payment_types ppt
112: -- hr_soft_coding_keyflex hsck
113: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
114: and hou.business_group_id = ppa.business_group_id
115: --and hoi.org_information_context(+) = 'IE_PAYPATH_INFORMATION' --15971893
116: --and hou.organization_id = hoi.organization_id --15971893
117: and hou.organization_id = ppa.business_group_id --15971893

Line 118: and popmu.org_payment_method_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD_ID'),popmu.org_payment_method_id)

114: and hou.business_group_id = ppa.business_group_id
115: --and hoi.org_information_context(+) = 'IE_PAYPATH_INFORMATION' --15971893
116: --and hou.organization_id = hoi.organization_id --15971893
117: and hou.organization_id = ppa.business_group_id --15971893
118: and popmu.org_payment_method_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD_ID'),popmu.org_payment_method_id)
119: and popmf.payment_type_id = ppt.payment_type_id
120: and ppt.payment_type_name = 'SEPA'
121: and ppa.effective_date between popmu.effective_start_date and popmu.effective_end_date
122: and popmf.org_payment_method_id = popmu.org_payment_method_id

Line 155: Group by to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')

151: -- and hsck.segment4 = hou.organization_id
152: AND ppa.effective_date between paaf.effective_start_date and paaf.effective_end_date
153: AND ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date
154: )
155: Group by to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')
156: ,hou.name
157: ,hou.organization_id
158: ,pea.external_account_id
159: ,NVL(pea.SEGMENT7,' ')

Line 193: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

189: ,pay_payroll_actions ppa
190: ,pay_personal_payment_methods_f ppmf
191: ,pay_external_accounts pea
192: --,hr_soft_coding_keyflex hsck
193: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
194: AND paa.pre_payment_id = ppp.pre_payment_id
195: AND paa.payroll_action_id = ppa.payroll_action_id
196: AND PPP.personal_payment_method_id = ppmf.personal_payment_method_id
197: AND ppmf.org_payment_method_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH_ID')

Line 197: AND ppmf.org_payment_method_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH_ID')

193: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
194: AND paa.pre_payment_id = ppp.pre_payment_id
195: AND paa.payroll_action_id = ppa.payroll_action_id
196: AND PPP.personal_payment_method_id = ppmf.personal_payment_method_id
197: AND ppmf.org_payment_method_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH_ID')
198: AND paa.assignment_id = paf.assignment_id
199: AND paf.payroll_id = NVL(ppa.payroll_id,paf.payroll_id)
200: AND paf.person_id = pef.person_id
201: AND ppf.payroll_id = paf.payroll_id

Line 205: --AND ppf.prl_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')

201: AND ppf.payroll_id = paf.payroll_id
202: AND ppa.effective_date BETWEEN ppf.effective_start_date
203: AND ppf.effective_end_date
204: --AND ppf.prl_information_category = 'NL'
205: --AND ppf.prl_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
206: --and ppf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
207: --and hsck.segment4 = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
208: AND ppp.value > 0
209: AND pea.external_account_id = ppmf.external_account_id

Line 207: --and hsck.segment4 = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')

203: AND ppf.effective_end_date
204: --AND ppf.prl_information_category = 'NL'
205: --AND ppf.prl_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
206: --and ppf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
207: --and hsck.segment4 = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
208: AND ppp.value > 0
209: AND pea.external_account_id = ppmf.external_account_id
210: AND ppa.effective_date BETWEEN paf.effective_start_date
211: AND paf.effective_end_date