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 --13931157

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 --13931157
124: and decode(ppa1.action_type,'R',ppa1.date_earned,'Q',ppa1.date_earned,'V',ppa1.effective_date) --13931157

Line 147: from pay_payroll_actions ppa1, pay_assignment_actions paa1,

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

Line 148: pay_payroll_actions ppa2,

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

Line 173: from pay_payroll_actions ppa1, pay_assignment_actions paa1,

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

Line 174: pay_payroll_actions ppa2,

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

Line 206: -- Get all transactions from pay_payroll_actions

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

Line 216: FROM PAY_PAYROLL_ACTIONS

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

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

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

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

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