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_PAYROLL_ACTIONS

Line 14: -- to return parameter values from legislative parameters in pay_payroll_actions

10: -- all the people in the business group.
11: -- The archiver uses this cursor to split the people into chunks for parallel
12: -- processing.
13: --
14: -- to return parameter values from legislative parameters in pay_payroll_actions
15: --
16:
17: PROCEDURE range_cursor(
18: p_payroll_action_id IN NUMBER,

Line 62: FROM pay_payroll_actions ppa,

58: ,paf.payroll_id
59: ,'PAYROLL_ACTION_ID=C'
60: ,ppa.payroll_action_id
61:
62: FROM pay_payroll_actions ppa,
63: pay_assignment_actions paa,
64: per_all_assignments_f paf,
65: pay_pre_payments ppp,
66: pay_org_payment_methods_f pop,

Line 113: pay_payroll_actions ppa,

109: ,'ASSIGNMENT_ACTION_ID=C', paa.assignment_action_id
110:
111: FROM pay_assignment_actions paa,
112: per_all_assignments_f paf,
113: pay_payroll_actions ppa,
114: pay_pre_payments ppp,
115: PAY_ORG_PAYMENT_METHODS_F pop,
116: per_all_people_f pef,
117: pay_external_accounts pea,

Line 171: pay_payroll_actions pa2,

167: ,'LAST_NAME=P'
168: ,substr(pap.last_name,1,35)
169: FROM pay_assignment_actions act,
170: per_all_assignments_f asg,
171: pay_payroll_actions pa2,
172: pay_payroll_actions pa1,
173: pay_pre_payments ppp,
174: pay_org_payment_methods_f OPM,
175: per_all_people_f pap,

Line 172: pay_payroll_actions pa1,

168: ,substr(pap.last_name,1,35)
169: FROM pay_assignment_actions act,
170: per_all_assignments_f asg,
171: pay_payroll_actions pa2,
172: pay_payroll_actions pa1,
173: pay_pre_payments ppp,
174: pay_org_payment_methods_f OPM,
175: per_all_people_f pap,
176: -- hr_soft_coding_keyflex hsk,

Line 211: pay_payroll_actions appa

207: ))
208: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
209: FROM pay_action_interlocks pai1,
210: pay_assignment_actions act2,
211: pay_payroll_actions appa
212: WHERE pai1.locked_action_id = act.assignment_action_id
213: AND act2.assignment_action_id = pai1.locking_action_id
214: AND act2.payroll_action_id = appa.payroll_action_id
215: AND appa.action_type = 'X'

Line 252: pay_payroll_actions pa2,

248: ,'LAST_NAME=P'
249: ,substr(pap.last_name,1,35)
250: FROM pay_assignment_actions act,
251: per_all_assignments_f asg,
252: pay_payroll_actions pa2,
253: pay_payroll_actions pa1,
254: pay_pre_payments ppp,
255: pay_org_payment_methods_f OPM,
256: per_all_people_f pap,

Line 253: pay_payroll_actions pa1,

249: ,substr(pap.last_name,1,35)
250: FROM pay_assignment_actions act,
251: per_all_assignments_f asg,
252: pay_payroll_actions pa2,
253: pay_payroll_actions pa1,
254: pay_pre_payments ppp,
255: pay_org_payment_methods_f OPM,
256: per_all_people_f pap,
257: -- hr_soft_coding_keyflex hsk,

Line 293: pay_payroll_actions appa

289: ))
290: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
291: FROM pay_action_interlocks pai1,
292: pay_assignment_actions act2,
293: pay_payroll_actions appa
294: WHERE pai1.locked_action_id = act.assignment_action_id
295: AND act2.assignment_action_id = pai1.locking_action_id
296: AND act2.payroll_action_id = appa.payroll_action_id
297: AND appa.action_type = 'X'

Line 329: pay_payroll_actions ppa,

325: ,pea.segment6
326:
327: FROM pay_assignment_actions paa,
328: per_all_assignments_f paf,
329: pay_payroll_actions ppa,
330: pay_pre_payments ppp,
331: pay_org_payment_methods_f pop,
332: per_all_people_f pef,
333: -- per_addresses pad,