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_NO_PAYPROC dependencies on PAY_NO_PAYPROC_UTILITY

Line 30: ,nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)

26:
27:
28: CURSOR CSR_NO_PP_HEADER IS
29: SELECT distinct 'ENTERPRISE_NUMBER=P'
30: ,nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)
31: ,'CREATION_DATE=P'
32: ,to_char(ppa.effective_date, 'YYYYMMDD')
33: ,'PAYMENT_DATE=P'
34: ,to_char(fnd_date.canonical_to_date(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PAYMENT_DATE')), 'YYYYMMDD')

Line 34: ,to_char(fnd_date.canonical_to_date(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PAYMENT_DATE')), 'YYYYMMDD')

30: ,nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)
31: ,'CREATION_DATE=P'
32: ,to_char(ppa.effective_date, 'YYYYMMDD')
33: ,'PAYMENT_DATE=P'
34: ,to_char(fnd_date.canonical_to_date(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PAYMENT_DATE')), 'YYYYMMDD')
35: ,'LEGAL_EMPLOYER=P'
36: , to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
37: ,'AH_SEQ_NO=P'
38: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'AH_SEQUENCE_NUMBER'))

Line 36: , to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))

32: ,to_char(ppa.effective_date, 'YYYYMMDD')
33: ,'PAYMENT_DATE=P'
34: ,to_char(fnd_date.canonical_to_date(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PAYMENT_DATE')), 'YYYYMMDD')
35: ,'LEGAL_EMPLOYER=P'
36: , to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
37: ,'AH_SEQ_NO=P'
38: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'AH_SEQUENCE_NUMBER'))
39: ,'DIVISION=P'
40: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'DIVISION')

Line 38: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'AH_SEQUENCE_NUMBER'))

34: ,to_char(fnd_date.canonical_to_date(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PAYMENT_DATE')), 'YYYYMMDD')
35: ,'LEGAL_EMPLOYER=P'
36: , to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
37: ,'AH_SEQ_NO=P'
38: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'AH_SEQUENCE_NUMBER'))
39: ,'DIVISION=P'
40: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'DIVISION')
41: ,'PASSWORD=P'
42: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PASSWORD')

Line 40: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'DIVISION')

36: , to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
37: ,'AH_SEQ_NO=P'
38: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'AH_SEQUENCE_NUMBER'))
39: ,'DIVISION=P'
40: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'DIVISION')
41: ,'PASSWORD=P'
42: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PASSWORD')
43: ,'NEW_PASSWORD=P'
44: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'NEW_PASSWORD')

Line 42: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PASSWORD')

38: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'AH_SEQUENCE_NUMBER'))
39: ,'DIVISION=P'
40: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'DIVISION')
41: ,'PASSWORD=P'
42: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PASSWORD')
43: ,'NEW_PASSWORD=P'
44: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'NEW_PASSWORD')
45: ,'SEQ_CONTROL=P'
46: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'SEQUENCE_CONTROL'))

Line 44: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'NEW_PASSWORD')

40: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'DIVISION')
41: ,'PASSWORD=P'
42: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PASSWORD')
43: ,'NEW_PASSWORD=P'
44: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'NEW_PASSWORD')
45: ,'SEQ_CONTROL=P'
46: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'SEQUENCE_CONTROL'))
47: ,'MAGNETIC_FILE_NAME=P'
48: ,ppa.magnetic_file_name

Line 46: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'SEQUENCE_CONTROL'))

42: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PASSWORD')
43: ,'NEW_PASSWORD=P'
44: ,PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'NEW_PASSWORD')
45: ,'SEQ_CONTROL=P'
46: ,to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'SEQUENCE_CONTROL'))
47: ,'MAGNETIC_FILE_NAME=P'
48: ,ppa.magnetic_file_name
49: ,'REPORT_FILE_NAME=P'
50: ,ppa.report_file_name

Line 84: order by nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1);

80: and ppu.payroll_id = paf.payroll_id
81: and pop.org_payment_method_id = ppu.org_payment_method_id
82: and ppa.effective_date between pop.effective_start_date and pop.effective_end_date
83: -- and rownum < 2;
84: order by nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1);
85:
86: CURSOR CSR_NO_PP_BODY IS
87:
88: SELECT 'AMOUNT=P'

Line 99: ,PAY_NO_PAYPROC_UTILITY.get_account_no(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date)

95: ,substr(pef.last_name,1,35)
96: ,'ORG_ACCOUNT_NO=P'
97: ,pea.segment6
98: ,'EXTERNAL_ACCOUNT=P'
99: ,PAY_NO_PAYPROC_UTILITY.get_account_no(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date)
100: ,'MASS_OR_INVOICE_F=P'
101: ,PAY_NO_PAYPROC_UTILITY.get_payment_invoice_or_mass(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date) mass_or_invoice
102: ,'ASSIGNMENT_ID=C' , paf.assignment_id
103: ,'BUSINESS_GROUP_ID=C' , paf.business_group_id

Line 101: ,PAY_NO_PAYPROC_UTILITY.get_payment_invoice_or_mass(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date) mass_or_invoice

97: ,pea.segment6
98: ,'EXTERNAL_ACCOUNT=P'
99: ,PAY_NO_PAYPROC_UTILITY.get_account_no(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date)
100: ,'MASS_OR_INVOICE_F=P'
101: ,PAY_NO_PAYPROC_UTILITY.get_payment_invoice_or_mass(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date) mass_or_invoice
102: ,'ASSIGNMENT_ID=C' , paf.assignment_id
103: ,'BUSINESS_GROUP_ID=C' , paf.business_group_id
104: ,'PER_PAY_METHOD_ID=C' , NVL(ppp.personal_payment_method_id,PAY_NO_PAYPROC_UTILITY.get_payment_method_id(paf.payroll_id,ppa.effective_date))
105: ,'ORG_PAY_METHOD_ID=C' , nvl(ppp.org_payment_method_id,ppf.DEFAULT_PAYMENT_METHOD_ID)

Line 104: ,'PER_PAY_METHOD_ID=C' , NVL(ppp.personal_payment_method_id,PAY_NO_PAYPROC_UTILITY.get_payment_method_id(paf.payroll_id,ppa.effective_date))

100: ,'MASS_OR_INVOICE_F=P'
101: ,PAY_NO_PAYPROC_UTILITY.get_payment_invoice_or_mass(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date) mass_or_invoice
102: ,'ASSIGNMENT_ID=C' , paf.assignment_id
103: ,'BUSINESS_GROUP_ID=C' , paf.business_group_id
104: ,'PER_PAY_METHOD_ID=C' , NVL(ppp.personal_payment_method_id,PAY_NO_PAYPROC_UTILITY.get_payment_method_id(paf.payroll_id,ppa.effective_date))
105: ,'ORG_PAY_METHOD_ID=C' , nvl(ppp.org_payment_method_id,ppf.DEFAULT_PAYMENT_METHOD_ID)
106: ,'DATE_EARNED=C' , to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')
107: ,'PAYROLL_ID=C' , paf.payroll_id
108: ,'PAYROLL_ACTION_ID=C' , ppa.payroll_action_id

Line 132: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)= pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO')

128: and ppt.payment_type_id= pop.payment_type_id
129: and ( ppt.payment_type_name like 'NO Money Order' or ppt.category in ('MT'))
130: and pop.external_account_id = pea.external_account_id
131: and paa.assignment_id = paf.assignment_id
132: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)= pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO')
133: /* and hsk.SOFT_CODING_KEYFLEX_ID = paf.SOFT_CODING_KEYFLEX_ID
134: and hsk.enabled_flag = 'Y'
135: and hsk.segment2 in (
136: select hoi2.org_information1

Line 142: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))

138: , HR_ORGANIZATION_INFORMATION hoi1
139: , HR_ORGANIZATION_INFORMATION hoi2
140: WHERE o1.business_group_id = ppa.business_group_id
141: and hoi1.organization_id = o1.organization_id
142: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
143: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
144: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
145: and hoi1.organization_id = hoi2.organization_id
146: and hoi2.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNITS'

Line 153: and ppf.payroll_id = PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PAYROLL_ID')

149: and paf.payroll_id = nvl(ppa.payroll_id,paf.payroll_id )
150: and ppa.effective_date between pop.effective_start_date and pop.effective_end_date
151: and ppa.effective_date between paf.effective_start_date and paf.effective_end_date
152: and ppa.effective_date between pef.effective_start_date and pef.effective_end_date
153: and ppf.payroll_id = PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PAYROLL_ID')
154: and ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date
155: ORDER BY nvl(ppp.org_payment_method_id,ppf.DEFAULT_PAYMENT_METHOD_ID),
156: mass_or_invoice,paf.organization_id,substr(pef.last_name || ' ' || pef.first_name,1,50);
157: ---------------------------------------------------------------------------------------

Line 180: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)

176: -- hr_soft_coding_keyflex hsk,
177: pay_payment_types ppt
178:
179: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
180: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
181: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
182: AND pa2.effective_date <= pa1.effective_date
183: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
184: AND act.payroll_action_id = pa2.payroll_action_id

Line 181: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))

177: pay_payment_types ppt
178:
179: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
180: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
181: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
182: AND pa2.effective_date <= pa1.effective_date
183: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
184: AND act.payroll_action_id = pa2.payroll_action_id
185: AND act.action_status = 'C'

Line 202: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL

198: FROM per_addresses pad
199: WHERE pad.person_id = asg.person_id
200: and pad.PRIMARY_FLAG ='Y')
201: )
202: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
203: OR EXISTS ( SELECT ''
204: FROM hr_assignment_set_amendments hr_asg
205: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
206: AND hr_asg.assignment_id = asg.assignment_id

Line 205: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))

201: )
202: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
203: OR EXISTS ( SELECT ''
204: FROM hr_assignment_set_amendments hr_asg
205: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
206: AND hr_asg.assignment_id = asg.assignment_id
207: ))
208: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
209: FROM pay_action_interlocks pai1,

Line 227: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))

223: , HR_ORGANIZATION_INFORMATION hoi1
224: , HR_ORGANIZATION_INFORMATION hoi2
225: WHERE o1.business_group_id = pa1.business_group_id
226: and hoi1.organization_id = o1.organization_id
227: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))
228: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
229: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
230: and hoi1.organization_id = hoi2.organization_id
231: and hoi2.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNITS'

Line 260: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)

256: per_all_people_f pap,
257: -- hr_soft_coding_keyflex hsk,
258: pay_payment_types ppt
259: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
260: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
261: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
262: AND pa2.effective_date <= pa1.effective_date
263: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
264: AND act.payroll_action_id = pa2.payroll_action_id

Line 261: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))

257: -- hr_soft_coding_keyflex hsk,
258: pay_payment_types ppt
259: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
260: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
261: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
262: AND pa2.effective_date <= pa1.effective_date
263: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
264: AND act.payroll_action_id = pa2.payroll_action_id
265: AND act.action_status = 'C'

Line 284: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL

280: WHERE ppp1.assignment_action_id = act.assignment_action_id--2023513440
281: AND ppp1.org_payment_method_id = opm1.org_payment_method_id
282: AND ppt1.payment_type_id= opm1.payment_type_id
283: AND ppt1.category in ('MT')))
284: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
285: OR EXISTS ( SELECT ''
286: FROM hr_assignment_set_amendments hr_asg
287: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
288: AND hr_asg.assignment_id = asg.assignment_id

Line 287: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))

283: AND ppt1.category in ('MT')))
284: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
285: OR EXISTS ( SELECT ''
286: FROM hr_assignment_set_amendments hr_asg
287: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
288: AND hr_asg.assignment_id = asg.assignment_id
289: ))
290: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
291: FROM pay_action_interlocks pai1,

Line 308: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))

304: , HR_ORGANIZATION_INFORMATION hoi1
305: , HR_ORGANIZATION_INFORMATION hoi2
306: WHERE o1.business_group_id = pa1.business_group_id
307: and hoi1.organization_id = o1.organization_id
308: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))
309: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
310: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
311: and hoi1.organization_id = hoi2.organization_id
312: and hoi2.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNITS' ) */

Line 339: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))

335: -- hr_soft_coding_keyflex hsk,
336: pay_payment_types ppt
337:
338: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
339: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
340: and ppp.pre_payment_id = paa.pre_payment_id
341: and ppp.value > 0
342: and paa.payroll_action_id = ppa.payroll_action_id
343: and pop.org_payment_method_id = ppp.org_payment_method_id

Line 362: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))

358: , HR_ORGANIZATION_INFORMATION hoi1
359: , HR_ORGANIZATION_INFORMATION hoi2
360: WHERE o1.business_group_id = ppa.business_group_id
361: and hoi1.organization_id = o1.organization_id
362: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
363: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
364: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
365: and hoi1.organization_id = hoi2.organization_id
366: and hoi2.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNITS'