APPS.PSP_PAYTRN dependencies on PAY_PAYROLL_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 120: pay_payroll_actions ppa2,

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
124: and ppa1.action_type IN ('R','Q','V') -- regular run, quick_pay, reversals

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 146: pay_payroll_actions ppa2,

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
150: and ppa2.payroll_id=l_payroll_id

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 172: pay_payroll_actions ppa2,

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
176: and ppa2.payroll_id=l_payroll_id

Line 204: -- Get all transactions from pay_payroll_actions

200:
201:
202:
203:
204: -- Get all transactions from pay_payroll_actions
205: -- based on effective_date between payroll_start_date
206: -- and payroll_end_date
207: CURSOR get_payroll_actions_csr is
208: SELECT payroll_id,

Line 214: FROM PAY_PAYROLL_ACTIONS

210: effective_date,
211: date_earned,
212: time_period_id,
213: pay_advice_date
214: FROM PAY_PAYROLL_ACTIONS
215: WHERE effective_date between l_start_date and l_end_date and
216: payroll_id = l_payroll_id and
217: action_type in ('R','Q') and action_status = 'C';
218: action type changed from 'C' to (R. Q) to fix bug 1004191

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