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 33: ,to_char(fnd_date.canonical_to_date(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'PAYMENT_DATE')), 'YYYYMMDD')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

83: ,substr(pef.last_name,1,35)
84: ,'ORG_ACCOUNT_NO=P'
85: ,pea.segment6
86: ,'EXTERNAL_ACCOUNT=P'
87: ,PAY_NO_PAYPROC_UTILITY.get_account_no(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date)
88: ,'MASS_OR_INVOICE_F=P'
89: ,PAY_NO_PAYPROC_UTILITY.get_payment_invoice_or_mass(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date) mass_or_invoice
90: ,'ASSIGNMENT_ID=C' , paf.assignment_id
91: ,'BUSINESS_GROUP_ID=C' , paf.business_group_id

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

85: ,pea.segment6
86: ,'EXTERNAL_ACCOUNT=P'
87: ,PAY_NO_PAYPROC_UTILITY.get_account_no(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date)
88: ,'MASS_OR_INVOICE_F=P'
89: ,PAY_NO_PAYPROC_UTILITY.get_payment_invoice_or_mass(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date) mass_or_invoice
90: ,'ASSIGNMENT_ID=C' , paf.assignment_id
91: ,'BUSINESS_GROUP_ID=C' , paf.business_group_id
92: ,'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))
93: ,'ORG_PAY_METHOD_ID=C' , ppp.org_payment_method_id

Line 92: ,'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))

88: ,'MASS_OR_INVOICE_F=P'
89: ,PAY_NO_PAYPROC_UTILITY.get_payment_invoice_or_mass(ppp.personal_payment_method_id,paf.payroll_id,ppa.effective_date) mass_or_invoice
90: ,'ASSIGNMENT_ID=C' , paf.assignment_id
91: ,'BUSINESS_GROUP_ID=C' , paf.business_group_id
92: ,'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))
93: ,'ORG_PAY_METHOD_ID=C' , ppp.org_payment_method_id
94: ,'DATE_EARNED=C' , to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')
95: ,'PAYROLL_ID=C' , paf.payroll_id
96: ,'PAYROLL_ACTION_ID=C' , ppa.payroll_action_id

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

123: , HR_ORGANIZATION_INFORMATION hoi1
124: , HR_ORGANIZATION_INFORMATION hoi2
125: WHERE o1.business_group_id = ppa.business_group_id
126: and hoi1.organization_id = o1.organization_id
127: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
128: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
129: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
130: and hoi1.organization_id = hoi2.organization_id
131: and hoi2.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNITS'

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

158: hr_soft_coding_keyflex hsk,
159: pay_payment_types ppt
160:
161: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
162: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
163: AND pa2.effective_date <= pa1.effective_date
164: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
165: AND act.payroll_action_id = pa2.payroll_action_id
166: AND act.action_status = 'C'

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

178: FROM per_addresses pad
179: WHERE pad.person_id = asg.person_id
180: and pad.PRIMARY_FLAG ='Y')
181: )
182: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
183: OR EXISTS ( SELECT ''
184: FROM hr_assignment_set_amendments hr_asg
185: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
186: AND hr_asg.assignment_id = asg.assignment_id

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

181: )
182: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
183: OR EXISTS ( SELECT ''
184: FROM hr_assignment_set_amendments hr_asg
185: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
186: AND hr_asg.assignment_id = asg.assignment_id
187: ))
188: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
189: FROM pay_action_interlocks pai1,

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

203: , HR_ORGANIZATION_INFORMATION hoi1
204: , HR_ORGANIZATION_INFORMATION hoi2
205: WHERE o1.business_group_id = pa1.business_group_id
206: and hoi1.organization_id = o1.organization_id
207: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))
208: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
209: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
210: and hoi1.organization_id = hoi2.organization_id
211: and hoi2.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNITS'

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

236: per_all_people_f pap,
237: hr_soft_coding_keyflex hsk,
238: pay_payment_types ppt
239: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
240: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
241: AND pa2.effective_date <= pa1.effective_date
242: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
243: AND act.payroll_action_id = pa2.payroll_action_id
244: AND act.action_status = 'C'

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

258: WHERE ppp1.assignment_action_id = act.assignment_action_id--2023513440
259: AND ppp1.org_payment_method_id = opm1.org_payment_method_id
260: AND ppt1.payment_type_id= opm1.payment_type_id
261: AND ppt1.category in ('MT')))
262: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
263: OR EXISTS ( SELECT ''
264: FROM hr_assignment_set_amendments hr_asg
265: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
266: AND hr_asg.assignment_id = asg.assignment_id

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

261: AND ppt1.category in ('MT')))
262: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
263: OR EXISTS ( SELECT ''
264: FROM hr_assignment_set_amendments hr_asg
265: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
266: AND hr_asg.assignment_id = asg.assignment_id
267: ))
268: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
269: FROM pay_action_interlocks pai1,

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

282: , HR_ORGANIZATION_INFORMATION hoi1
283: , HR_ORGANIZATION_INFORMATION hoi2
284: WHERE o1.business_group_id = pa1.business_group_id
285: and hoi1.organization_id = o1.organization_id
286: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))
287: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
288: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
289: and hoi1.organization_id = hoi2.organization_id
290: and hoi2.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNITS' )

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

329: , HR_ORGANIZATION_INFORMATION hoi1
330: , HR_ORGANIZATION_INFORMATION hoi2
331: WHERE o1.business_group_id = ppa.business_group_id
332: and hoi1.organization_id = o1.organization_id
333: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
334: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
335: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
336: and hoi1.organization_id = hoi2.organization_id
337: and hoi2.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNITS'