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

Line 83: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

79: , pay_consolidation_sets pcs
80: , pay_all_payrolls_f pap
81: , pay_external_accounts pea
82: , pay_org_payment_methods_f pop
83: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
84: AND pap.payroll_id = ppa.payroll_id
85: AND pcs.consolidation_set_id = pap.consolidation_set_id
86: AND pop.org_payment_method_id = ppa.org_payment_method_id
87: AND pop.external_account_id = pea.external_account_id

Line 108: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

104: , hoi2.org_information1
105: , 'TRANSFER_LE_ID=P'
106: , to_char(hou.ORGANIZATION_ID)
107: , 'PAYROLL_ACTION_ID=C'
108: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
109: FROM pay_payroll_actions ppa
110: , hr_organization_units hou
111: , hr_organization_information hoi1
112: , hr_organization_information hoi2

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

109: FROM pay_payroll_actions ppa
110: , hr_organization_units hou
111: , hr_organization_information hoi1
112: , hr_organization_information hoi2
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 hoi1.organization_id = hou.organization_id
116: AND hoi1.org_information_context='CLASS'
117: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 121: AND nvl(hoi2.org_information1,0)= nvl2(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'DS_NAME',null),pay_magtape_generic.get_parameter_value('TRANSFER_DS_CVR_NO') ,nvl(hoi2.org_information1,0))

117: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
118: AND hoi1.org_information2 = 'Y'
119: AND hoi2.org_information_context='DK_LEGAL_ENTITY_DETAILS'
120: AND hoi2.organization_id = hoi1.organization_id
121: AND nvl(hoi2.org_information1,0)= nvl2(PAY_DK_PAYMENT_PROCESS_PKG.get_parameter(legislative_parameters,'DS_NAME',null),pay_magtape_generic.get_parameter_value('TRANSFER_DS_CVR_NO') ,nvl(hoi2.org_information1,0))
122: AND ppa.effective_date BETWEEN hou.date_from AND nvl(hou.date_to, ppa.effective_date);
123:
124:
125: CURSOR get_transfer_record_details IS

Line 144: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

140: , pay_assignment_actions paa
141: , pay_pre_payments ppp
142: , pay_external_accounts pea
143: , pay_personal_payment_methods_f ppm
144: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
145: AND paf.business_group_id = ppa.business_group_id
146: AND paf.payroll_id = ppa.PAYROLL_ID
147: AND pap.per_information_category ='DK'
148: AND paf.person_id = pap.person_id

Line 153: AND scl.segment1 = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID')

149: AND paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
150: AND ppa.effective_date between paf.effective_start_date AND paf.effective_end_date
151: AND ppa.effective_date between pap.effective_start_date AND pap.effective_end_date
152: AND scl.enabled_flag = 'Y'
153: AND scl.segment1 = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID')
154: AND paa.payroll_action_id = ppa.payroll_action_id
155: AND ppp.pre_payment_id = paa.pre_payment_id
156: AND paa.assignment_id = paf.assignment_id
157: AND ppm.personal_payment_method_id = ppp.personal_payment_method_id

Line 181: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

177: , pay_user_rows_f pur
178: , pay_user_columns puc1
179: , pay_user_column_instances_f puci1
180: , pay_user_rows_f pur1
181: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
182: AND put.user_table_name = 'DK_PBS_DATA'
183: AND put.LEGISLATION_CODE ='DK'
184: AND puc.user_table_id = put.user_table_id
185: AND puc.user_column_name = 'Information Type'

Line 212: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

208: FROM pay_payroll_actions ppa
209: , hr_organization_units hou
210: , hr_organization_information hoi1
211: , hr_organization_information hoi2
212: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
213: AND hou.business_group_id = ppa.business_group_id
214: AND hoi1.organization_id = hou.organization_id
215: AND hoi1.org_information_context='CLASS'
216: AND hoi1.org_information1 = 'DK_PENSION_PROVIDER'

Line 256: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

252: , to_char(ppa.effective_date)
253: , 'BUSINESS_GROUP_ID=P'
254: , to_char(ppa.business_group_id)
255: , 'PAYROLL_ACTION_ID=C'
256: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
257: , 'ORGANIZATION_ID=C'
258: , peev.screen_entry_value
259: , 'TRANSFER_ORGANIZATION_ID=P'
260: , peev.screen_entry_value

Line 282: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

278: ,pay_element_entries_f peef
279: ,pay_element_types_f petf
280: ,pay_input_values_f pivf
281: ,pay_element_entry_values_f peev
282: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
283: AND paf.business_group_id = ppa.business_group_id
284: AND paf.payroll_id = ppa.payroll_id
285: AND pap.per_information_category ='DK'
286: AND paf.person_id = pap.person_id

Line 291: AND scl.segment1 = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID')

287: AND paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
288: AND ppa.effective_date between paf.effective_start_date AND paf.effective_end_date
289: AND ppa.effective_date between pap.effective_start_date AND pap.effective_end_date
290: AND scl.enabled_flag = 'Y'
291: AND scl.segment1 = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID')
292: /* Added for bug fix 4554812 */
293: /* Removed and re-wrote in function get_pension_provider */
294: /*AND hou.name = pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')*/
295: /* Removed and re-written for pension changes to get pension provider */

Line 294: /AND hou.name = pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')/

290: AND scl.enabled_flag = 'Y'
291: AND scl.segment1 = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID')
292: /* Added for bug fix 4554812 */
293: /* Removed and re-wrote in function get_pension_provider */
294: /*AND hou.name = pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')*/
295: /* Removed and re-written for pension changes to get pension provider */
296: /*AND nvl(scl.segment2,0) = decode(pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE')
297: , 300 , nvl(scl.segment2,0)
298: , 400 , nvl(scl.segment2,0)

Line 296: /*AND nvl(scl.segment2,0) = decode(pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE')

292: /* Added for bug fix 4554812 */
293: /* Removed and re-wrote in function get_pension_provider */
294: /*AND hou.name = pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')*/
295: /* Removed and re-written for pension changes to get pension provider */
296: /*AND nvl(scl.segment2,0) = decode(pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE')
297: , 300 , nvl(scl.segment2,0)
298: , 400 , nvl(scl.segment2,0)
299: , 800 , nvl(scl.segment2,0)
300: , 900 , nvl(scl.segment2,0)

Line 301: , PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')))--to_char(hou.organization_id))

297: , 300 , nvl(scl.segment2,0)
298: , 400 , nvl(scl.segment2,0)
299: , 800 , nvl(scl.segment2,0)
300: , 900 , nvl(scl.segment2,0)
301: , PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')))--to_char(hou.organization_id))
302: */
303: /* Added for Pension changes -start */
304: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
305: AND peef.assignment_id = paf.assignment_id

Line 304: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

300: , 900 , nvl(scl.segment2,0)
301: , PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')))--to_char(hou.organization_id))
302: */
303: /* Added for Pension changes -start */
304: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
305: AND peef.assignment_id = paf.assignment_id
306: AND ppa.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
307: AND peef.element_type_id = petf.element_type_id
308: AND petf.legislation_code ='DK'

Line 315: AND peev.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

311: AND pivf.element_type_id = petf.element_type_id
312: AND pivf.input_value_id = peev.input_value_id
313: AND pivf.name= 'Third Party Payee'
314: AND peev.element_entry_id = peef.element_entry_id
315: AND peev.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
316: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
317: /* Added for Pension changes -end */
318: AND paa.payroll_action_id = ppa.payroll_action_id
319: AND ppp.pre_payment_id = paa.pre_payment_id

Line 354: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

350: , to_char(ppa.effective_date)
351: , 'BUSINESS_GROUP_ID=P'
352: , to_char(ppa.business_group_id)
353: , 'PAYROLL_ACTION_ID=C'
354: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
355: , 'ORGANIZATION_ID=C'
356: , null
357: , 'TRANSFER_ORGANIZATION_ID=P'
358: , null

Line 375: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

371: , pay_personal_payment_methods_f ppm
372: /* Added join for bug fix 4554812 */
373: /* Removed and re-wrote in function get_pension_provider */
374: /*, hr_organization_units hou */
375: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
376: AND paf.business_group_id = ppa.business_group_id
377: AND paf.payroll_id = ppa.payroll_id
378: AND pap.per_information_category ='DK'
379: AND paf.person_id = pap.person_id

Line 384: AND scl.segment1 = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID')

380: AND paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
381: AND ppa.effective_date between paf.effective_start_date AND paf.effective_end_date
382: AND ppa.effective_date between pap.effective_start_date AND pap.effective_end_date
383: AND scl.enabled_flag = 'Y'
384: AND scl.segment1 = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID')
385: /* Added for bug fix 4554812 */
386: /* Removed and re-wrote in function get_pension_provider */
387: /*AND hou.name = pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')*/
388: /* Removed and re-written for pension changes to get pension provider */

Line 387: /AND hou.name = pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')/

383: AND scl.enabled_flag = 'Y'
384: AND scl.segment1 = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID')
385: /* Added for bug fix 4554812 */
386: /* Removed and re-wrote in function get_pension_provider */
387: /*AND hou.name = pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')*/
388: /* Removed and re-written for pension changes to get pension provider */
389: /*AND nvl(scl.segment2,0) = decode(pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE')
390: , 300 , nvl(scl.segment2,0)
391: , 400 , nvl(scl.segment2,0)

Line 389: /*AND nvl(scl.segment2,0) = decode(pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE')

385: /* Added for bug fix 4554812 */
386: /* Removed and re-wrote in function get_pension_provider */
387: /*AND hou.name = pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')*/
388: /* Removed and re-written for pension changes to get pension provider */
389: /*AND nvl(scl.segment2,0) = decode(pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE')
390: , 300 , nvl(scl.segment2,0)
391: , 400 , nvl(scl.segment2,0)
392: , 800 , nvl(scl.segment2,0)
393: , 900 , nvl(scl.segment2,0)

Line 394: , PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')))--to_char(hou.organization_id))

390: , 300 , nvl(scl.segment2,0)
391: , 400 , nvl(scl.segment2,0)
392: , 800 , nvl(scl.segment2,0)
393: , 900 , nvl(scl.segment2,0)
394: , PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')))--to_char(hou.organization_id))
395: */
396: /* Added for Pension changes -start */
397: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') IN (300, 400, 800, 900)
398: /* Added for Pension changes -end */

Line 397: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') IN (300, 400, 800, 900)

393: , 900 , nvl(scl.segment2,0)
394: , PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME')))--to_char(hou.organization_id))
395: */
396: /* Added for Pension changes -start */
397: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') IN (300, 400, 800, 900)
398: /* Added for Pension changes -end */
399: AND paa.payroll_action_id = ppa.payroll_action_id
400: AND ppp.pre_payment_id = paa.pre_payment_id
401: AND paa.assignment_id = paf.assignment_id

Line 420: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

416: , paa.ASSIGNMENT_ID
417: , 'DATE_EARNED=C'
418: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
419: , 'PAYROLL_ACTION_ID=C'
420: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
421: , 'FULL_NAME=P'
422: , hou.name /*bug fix 4551283*/
423: FROM pay_payroll_actions ppa
424: , pay_assignment_actions paa

Line 433: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

429: /* Added for Pension changes */
430: , pay_input_values_f pivf
431: , pay_element_entry_values_f peev1
432: , pay_element_entry_values_f peev2
433: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
434: AND paa.payroll_action_id = ppa.payroll_action_id
435: AND pee1.assignment_id = paa.assignment_id
436: AND pet.element_name = 'Pension'
437: AND pet.legislation_code ='DK'

Line 449: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

445: AND pivf.name= 'Third Party Payee'
446: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
447: AND peev1.input_value_id = pivf.input_value_id
448: AND peev1.element_entry_id = pee1.element_entry_id
449: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
450: AND peev2.input_value_id = pivf.input_value_id
451: AND peev2.element_entry_id = pee2.element_entry_id
452: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
453: /* Added for Pension changes -end */

Line 452: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

448: AND peev1.element_entry_id = pee1.element_entry_id
449: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
450: AND peev2.input_value_id = pivf.input_value_id
451: AND peev2.element_entry_id = pee2.element_entry_id
452: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
453: /* Added for Pension changes -end */
454: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
455: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
456: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date

Line 454: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')

450: AND peev2.input_value_id = pivf.input_value_id
451: AND peev2.element_entry_id = pee2.element_entry_id
452: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
453: /* Added for Pension changes -end */
454: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
455: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
456: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
457: AND pee1.effective_start_date >= ppa.start_date
458: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

Line 458: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

454: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
455: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
456: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
457: AND pee1.effective_start_date >= ppa.start_date
458: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
459: AND hou.organization_id = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID') /*bug fix 4551283*/
460: AND ppa.effective_date BETWEEN hou.date_from AND nvl(hou.date_to, ppa.effective_date) /*bug fix 4551283*/
461: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id,hou.name;
462:

Line 459: AND hou.organization_id = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID') /bug fix 4551283/

455: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
456: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
457: AND pee1.effective_start_date >= ppa.start_date
458: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
459: AND hou.organization_id = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID') /*bug fix 4551283*/
460: AND ppa.effective_date BETWEEN hou.date_from AND nvl(hou.date_to, ppa.effective_date) /*bug fix 4551283*/
461: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id,hou.name;
462:
463:

Line 477: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

473: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
474: , 'ASSIGNMENT_ACTION_ID=C'
475: , PAY_DK_PAYMENT_PROCESS_PKG.get_ass_action_context(paa.ASSIGNMENT_ID)
476: , 'PAYROLL_ACTION_ID=C'
477: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
478: /* Added for bug fix 5563150 */
479: , 'ELEMENT_ENTRY_ID=P'
480: , to_char(pee1.element_entry_id)
481: , 'ELEMENT_TYPE_ID=P'

Line 492: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

488: /* Added for Pension changes */
489: , pay_input_values_f pivf
490: , pay_element_entry_values_f peev1
491: , pay_element_entry_values_f peev2
492: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
493: AND paa.payroll_action_id = ppa.payroll_action_id
494: AND pee1.assignment_id = paa.assignment_id
495: AND pet.element_name = 'Pension'
496: AND pet.legislation_code ='DK'

Line 508: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

504: AND pivf.name= 'Third Party Payee'
505: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
506: AND peev1.input_value_id = pivf.input_value_id
507: AND peev1.element_entry_id = pee1.element_entry_id
508: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
509: AND peev2.input_value_id = pivf.input_value_id
510: AND peev2.element_entry_id = pee2.element_entry_id
511: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
512: /* Added for Pension changes -end */

Line 511: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

507: AND peev1.element_entry_id = pee1.element_entry_id
508: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
509: AND peev2.input_value_id = pivf.input_value_id
510: AND peev2.element_entry_id = pee2.element_entry_id
511: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
512: /* Added for Pension changes -end */
513: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
514: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
515: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date

Line 513: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')

509: AND peev2.input_value_id = pivf.input_value_id
510: AND peev2.element_entry_id = pee2.element_entry_id
511: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
512: /* Added for Pension changes -end */
513: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
514: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
515: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
516: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
517: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id;

Line 514: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

510: AND peev2.element_entry_id = pee2.element_entry_id
511: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
512: /* Added for Pension changes -end */
513: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
514: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
515: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
516: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
517: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id;
518:

Line 533: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

529: , paa.ASSIGNMENT_ID
530: ,'DATE_EARNED=C'
531: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
532: , 'PAYROLL_ACTION_ID=C'
533: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
534: FROM pay_payroll_actions ppa
535: , pay_assignment_actions paa
536: , pay_element_entries_f pee1
537: , pay_element_types_f pet

Line 543: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

539: /* Added for Pension changes */
540: , pay_input_values_f pivf
541: , pay_element_entry_values_f peev1
542: , pay_element_entry_values_f peev2
543: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
544: AND paa.payroll_action_id = ppa.payroll_action_id
545: AND pee1.assignment_id = paa.assignment_id
546: AND pet.element_name = 'Pension'
547: AND pet.legislation_code ='DK'

Line 559: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

555: AND pivf.name= 'Third Party Payee'
556: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
557: AND peev1.input_value_id = pivf.input_value_id
558: AND peev1.element_entry_id = pee1.element_entry_id
559: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
560: AND peev2.input_value_id = pivf.input_value_id
561: AND peev2.element_entry_id = pee2.element_entry_id
562: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
563: /* Added for Pension changes -end */

Line 562: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

558: AND peev1.element_entry_id = pee1.element_entry_id
559: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
560: AND peev2.input_value_id = pivf.input_value_id
561: AND peev2.element_entry_id = pee2.element_entry_id
562: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
563: /* Added for Pension changes -end */
564: AND pee2.effective_start_date < ppa.start_date
565: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
566: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

Line 565: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')

561: AND peev2.element_entry_id = pee2.element_entry_id
562: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
563: /* Added for Pension changes -end */
564: AND pee2.effective_start_date < ppa.start_date
565: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
566: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
567: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
568: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
569: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id;

Line 566: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

562: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
563: /* Added for Pension changes -end */
564: AND pee2.effective_start_date < ppa.start_date
565: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
566: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
567: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
568: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
569: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id;
570:

Line 623: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

619: , pay_input_values_f piv4
620: , pay_assignment_actions paa
621: , pay_payroll_actions ppa
622: , pay_element_entries_f pee
623: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
624: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
625: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
626: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID
627: AND prrv3.RUN_RESULT_ID = prr1.RUN_RESULT_ID

Line 636: AND prrv3.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')

632: AND prrv1.input_value_id = piv1.input_value_id
633: AND piv3.ELEMENT_TYPE_ID = pet1.element_type_id
634: AND piv3.NAME ='Third Party Payee'
635: AND prrv3.input_value_id = piv3.input_value_id
636: AND prrv3.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
637: AND prr2.ELEMENT_TYPE_ID =pet2.ELEMENT_TYPE_ID
638: AND prrv2.RUN_RESULT_ID = prr2.RUN_RESULT_ID
639: AND prrv4.RUN_RESULT_ID = prr2.RUN_RESULT_ID
640: AND prrv4.RESULT_VALUE = prrv3.RESULT_VALUE

Line 649: AND prrv4.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')

645: AND prrv2.input_value_id = piv2.input_value_id
646: AND piv4.ELEMENT_TYPE_ID = pet2.element_type_id
647: AND piv4.NAME ='Third Party Payee'
648: AND prrv4.input_value_id = piv4.input_value_id
649: AND prrv4.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
650: AND prr1.assignment_action_id = paa.assignment_action_id
651: AND prr1.assignment_action_id=prr2.assignment_action_id
652: AND prr1.start_date = prr2.start_date
653: AND prr1.end_date = prr2.end_date

Line 654: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

650: AND prr1.assignment_action_id = paa.assignment_action_id
651: AND prr1.assignment_action_id=prr2.assignment_action_id
652: AND prr1.start_date = prr2.start_date
653: AND prr1.end_date = prr2.end_date
654: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
655: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
656: AND ppa.effective_date BETWEEN pet1.effective_start_date and pet1.effective_end_date
657: AND ppa.effective_date BETWEEN pet2.effective_start_date and pet2.effective_end_date
658: AND ppa.effective_date BETWEEN piv1.effective_start_date and piv1.effective_end_date

Line 655: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')

651: AND prr1.assignment_action_id=prr2.assignment_action_id
652: AND prr1.start_date = prr2.start_date
653: AND prr1.end_date = prr2.end_date
654: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
655: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
656: AND ppa.effective_date BETWEEN pet1.effective_start_date and pet1.effective_end_date
657: AND ppa.effective_date BETWEEN pet2.effective_start_date and pet2.effective_end_date
658: AND ppa.effective_date BETWEEN piv1.effective_start_date and piv1.effective_end_date
659: AND ppa.effective_date BETWEEN piv2.effective_start_date and piv2.effective_end_date

Line 690: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

686: , pay_input_values_f piv4
687: , pay_assignment_actions paa
688: , pay_payroll_actions ppa
689: , pay_element_entries_f pee
690: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
691: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
692: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
693: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID
694: AND prrv3.RUN_RESULT_ID = prr1.RUN_RESULT_ID

Line 703: AND prrv3.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')

699: AND prrv1.input_value_id = piv1.input_value_id
700: AND piv3.ELEMENT_TYPE_ID = pet1.element_type_id
701: AND piv3.NAME ='Third Party Payee'
702: AND prrv3.input_value_id = piv3.input_value_id
703: AND prrv3.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
704: AND prr2.ELEMENT_TYPE_ID =pet2.ELEMENT_TYPE_ID
705: AND prrv2.RUN_RESULT_ID = prr2.RUN_RESULT_ID
706: AND prrv4.RUN_RESULT_ID = prr2.RUN_RESULT_ID
707: AND prrv4.RESULT_VALUE = prrv3.RESULT_VALUE

Line 716: AND prrv4.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')

712: AND prrv2.input_value_id = piv2.input_value_id
713: AND piv4.ELEMENT_TYPE_ID = pet2.element_type_id
714: AND piv4.NAME ='Third Party Payee'
715: AND prrv4.input_value_id = piv4.input_value_id
716: AND prrv4.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
717: AND prr1.assignment_action_id = paa.assignment_action_id
718: AND prr1.assignment_action_id=prr2.assignment_action_id
719: AND prr1.start_date = prr2.start_date
720: AND prr1.end_date = prr2.end_date

Line 721: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

717: AND prr1.assignment_action_id = paa.assignment_action_id
718: AND prr1.assignment_action_id=prr2.assignment_action_id
719: AND prr1.start_date = prr2.start_date
720: AND prr1.end_date = prr2.end_date
721: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
722: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
723: AND ppa.effective_date BETWEEN pet1.effective_start_date and pet1.effective_end_date
724: AND ppa.effective_date BETWEEN pet2.effective_start_date and pet2.effective_end_date
725: AND ppa.effective_date BETWEEN piv1.effective_start_date and piv1.effective_end_date

Line 722: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')

718: AND prr1.assignment_action_id=prr2.assignment_action_id
719: AND prr1.start_date = prr2.start_date
720: AND prr1.end_date = prr2.end_date
721: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
722: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
723: AND ppa.effective_date BETWEEN pet1.effective_start_date and pet1.effective_end_date
724: AND ppa.effective_date BETWEEN pet2.effective_start_date and pet2.effective_end_date
725: AND ppa.effective_date BETWEEN piv1.effective_start_date and piv1.effective_end_date
726: AND ppa.effective_date BETWEEN piv2.effective_start_date and piv2.effective_end_date

Line 757: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

753: , pay_input_values_f piv4
754: , pay_assignment_actions paa
755: , pay_payroll_actions ppa
756: , pay_element_entries_f pee
757: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
758: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
759: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
760: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID
761: AND prrv3.RUN_RESULT_ID = prr1.RUN_RESULT_ID

Line 770: AND prrv3.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')

766: AND prrv1.input_value_id = piv1.input_value_id
767: AND piv3.ELEMENT_TYPE_ID = pet1.element_type_id
768: AND piv3.NAME ='Third Party Payee'
769: AND prrv3.input_value_id = piv3.input_value_id
770: AND prrv3.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
771: AND prr2.ELEMENT_TYPE_ID =pet2.ELEMENT_TYPE_ID
772: AND prrv2.RUN_RESULT_ID = prr2.RUN_RESULT_ID
773: AND prrv4.RUN_RESULT_ID = prr2.RUN_RESULT_ID
774: AND prrv4.RESULT_VALUE = prrv3.RESULT_VALUE

Line 783: AND prrv4.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')

779: AND prrv2.input_value_id = piv2.input_value_id
780: AND piv4.ELEMENT_TYPE_ID = pet2.element_type_id
781: AND piv4.NAME ='Third Party Payee'
782: AND prrv4.input_value_id = piv4.input_value_id
783: AND prrv4.RESULT_VALUE = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
784: AND prr1.assignment_action_id = paa.assignment_action_id
785: AND prr1.assignment_action_id=prr2.assignment_action_id
786: AND prr1.start_date = prr2.start_date
787: AND prr1.end_date = prr2.end_date

Line 788: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

784: AND prr1.assignment_action_id = paa.assignment_action_id
785: AND prr1.assignment_action_id=prr2.assignment_action_id
786: AND prr1.start_date = prr2.start_date
787: AND prr1.end_date = prr2.end_date
788: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
789: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
790: AND ppa.effective_date BETWEEN pet1.effective_start_date and pet1.effective_end_date
791: AND ppa.effective_date BETWEEN pet2.effective_start_date and pet2.effective_end_date
792: AND ppa.effective_date BETWEEN piv1.effective_start_date and piv1.effective_end_date

Line 789: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')

785: AND prr1.assignment_action_id=prr2.assignment_action_id
786: AND prr1.start_date = prr2.start_date
787: AND prr1.end_date = prr2.end_date
788: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
789: AND paa.assignment_id = pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ID')
790: AND ppa.effective_date BETWEEN pet1.effective_start_date and pet1.effective_end_date
791: AND ppa.effective_date BETWEEN pet2.effective_start_date and pet2.effective_end_date
792: AND ppa.effective_date BETWEEN piv1.effective_start_date and piv1.effective_end_date
793: AND ppa.effective_date BETWEEN piv2.effective_start_date and piv2.effective_end_date

Line 819: /* pad.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID') */

815: FROM per_addresses pad
816: /* Modified for bug fix 4593682 */
817: , per_all_people_f pap
818: WHERE pad.person_id (+)= pap.person_id
819: /* pad.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID') */
820: AND pap.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')
821: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900);
822:
823: END PAY_DK_PAYMENT_PROCESS_PKG;

Line 820: AND pap.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')

816: /* Modified for bug fix 4593682 */
817: , per_all_people_f pap
818: WHERE pad.person_id (+)= pap.person_id
819: /* pad.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID') */
820: AND pap.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')
821: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900);
822:
823: END PAY_DK_PAYMENT_PROCESS_PKG;

Line 821: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900);

817: , per_all_people_f pap
818: WHERE pad.person_id (+)= pap.person_id
819: /* pad.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID') */
820: AND pap.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')
821: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900);
822:
823: END PAY_DK_PAYMENT_PROCESS_PKG;