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.PSP_PAYTRN dependencies on PAY_ASSIGNMENT_ACTIONS

Line 119: from pay_payroll_actions ppa1, pay_assignment_actions paa1,

115: decode(ppa1.action_type,'V',decode(l_TGL_REVB_ACC_DATE,'C',ppa2.effective_date,
116: ppa1.effective_date),
117: decode(l_TGL_DATE_USED,'E',ppa1.date_earned,
118: ppa1.effective_date)) accounting_date
119: from pay_payroll_actions ppa1, pay_assignment_actions paa1,
120: pay_payroll_actions ppa2,
121: pay_assignment_actions paa2
122: where ppa1.payroll_id= l_payroll_id
123: and ppa1.date_earned between l_start_date and l_end_date

Line 121: pay_assignment_actions paa2

117: decode(l_TGL_DATE_USED,'E',ppa1.date_earned,
118: ppa1.effective_date)) accounting_date
119: from pay_payroll_actions ppa1, pay_assignment_actions paa1,
120: pay_payroll_actions ppa2,
121: pay_assignment_actions paa2
122: where ppa1.payroll_id= l_payroll_id
123: and ppa1.date_earned between l_start_date and l_end_date
124: and ppa1.action_type IN ('R','Q','V') -- regular run, quick_pay, reversals
125: and ppa1.payroll_action_id = paa1.payroll_action_id

Line 145: from pay_payroll_actions ppa1, pay_assignment_actions paa1,

141: decode(ppa2.action_type,'B',decode(l_TGL_REVB_ACC_DATE,'C',ppa1.effective_date,
142: ppa2.effective_date),
143: decode(l_TGL_DATE_USED,'E',ppa2.date_earned,
144: ppa2.effective_date)) accounting_date
145: from pay_payroll_actions ppa1, pay_assignment_actions paa1,
146: pay_payroll_actions ppa2,
147: pay_assignment_actions paa2
148: where ppa2.action_type = 'B'
149: and ppa2.date_earned between l_start_date and l_end_date

Line 147: pay_assignment_actions paa2

143: decode(l_TGL_DATE_USED,'E',ppa2.date_earned,
144: ppa2.effective_date)) accounting_date
145: from pay_payroll_actions ppa1, pay_assignment_actions paa1,
146: pay_payroll_actions ppa2,
147: pay_assignment_actions paa2
148: where ppa2.action_type = 'B'
149: and ppa2.date_earned between l_start_date and l_end_date
150: and ppa2.payroll_id=l_payroll_id
151: and ppa1.action_type='C' and

Line 171: from pay_payroll_actions ppa1, pay_assignment_actions paa1,

167: decode(ppa2.action_type,'B',decode(l_TGL_REVB_ACC_DATE,'C',ppa1.effective_date,
168: ppa2.effective_date),
169: decode(l_TGL_DATE_USED,'E',ppa2.date_earned,
170: ppa2.effective_date)) accounting_date
171: from pay_payroll_actions ppa1, pay_assignment_actions paa1,
172: pay_payroll_actions ppa2,
173: pay_assignment_actions paa2
174: where ppa2.action_type <> 'B'
175: and ppa1.effective_date between l_start_date and l_end_date

Line 173: pay_assignment_actions paa2

169: decode(l_TGL_DATE_USED,'E',ppa2.date_earned,
170: ppa2.effective_date)) accounting_date
171: from pay_payroll_actions ppa1, pay_assignment_actions paa1,
172: pay_payroll_actions ppa2,
173: pay_assignment_actions paa2
174: where ppa2.action_type <> 'B'
175: and ppa1.effective_date between l_start_date and l_end_date
176: and ppa2.payroll_id=l_payroll_id
177: and ppa1.action_type='C' and

Line 225: -- Get all transactions from pay_assignment_actions

221: --Declare a record for above cursor
222:
223: g_payroll_rec get_payroll_actions_csr%ROWTYPE;
224:
225: -- Get all transactions from pay_assignment_actions
226: -- based on payroll_action_id we got from payroll
227: -- actions we got from payroll actions cursor
228:
229:

Line 234: FROM PAY_ASSIGNMENT_ACTIONS a,

230: CURSOR get_assignment_actions_csr is
231: SELECT a.assignment_id,
232: a.assignment_action_id,
233: b.person_id
234: FROM PAY_ASSIGNMENT_ACTIONS a,
235: PER_ASSIGNMENTS_F b
236: WHERE a.payroll_action_id = g_payroll_rec.payroll_action_id
237: and a.action_status = 'C'
238: and (a.assignment_id = b.assignment_id and

Line 253: l_assignment_id PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE;

249: fixed by Subha, :- Caltech
250: */
251: --Declare variables for above cursor
252:
253: l_assignment_id PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE;
254: l_assignment_action_id number := 0;
255: l_person_id number := 0;
256: l_employee_name varchar2(240);
257: l_cur_rec number;

Line 276: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,

272: ptp.end_date tp_end_date,
273: ptp.time_period_id,
274: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
275: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
276: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
277: pay_input_values_f piv
278: WHERE a.assignment_action_id = l_assignment_action_id and
279: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
280: not exists ( select null

Line 318: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,

314: ptp.end_date tp_end_date,
315: ptp.time_period_id,
316: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
317: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
318: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
319: pay_input_values_f piv
320: WHERE a.assignment_action_id = l_assignment_action_id and
321: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
322: exists ( select null