[Home] [Help]
102: is
103: select max(paa.assignment_id) assignment_id
104: from pay_payroll_actions rppa,
105: pay_assignment_actions rpac,
106: per_assignments_f paa
107: where paa.person_id between p_start_person_id
108: and p_end_person_id
109: and rppa.business_group_id = g_pact.business_group_id
110: and rppa.effective_date between g_pact.start_date
242: select pac.assignment_id,
243: pps.person_id,
244: pps.final_process_date
245: from pay_assignment_actions pac,
246: per_assignments_f paa,
247: per_periods_of_service pps
248: where pac.assignment_action_id = p_assignment_action_id
249: and paa.assignment_id = pac.assignment_id
250: and pps.person_id = paa.person_id
275: is
276: select /*+ ORDERED USE_NL(pacmax) */
277: max(pacmax.action_sequence) act_seq,
278: to_char(ppamax.effective_date,'MM')
279: from per_assignments_f paamax,
280: pay_assignment_actions pacmax,
281: pay_payroll_actions ppamax
282: where ppamax.business_group_id = c_business_group_id
283: and pacmax.tax_unit_id = c_legal_entity_id
299: select /*+ ORDERED USE_NL(pac) */
300: pac.assignment_action_id assact_id,
301: decode(ppa.action_type,'V',ppa.effective_date,ppa.date_earned) date_earned,
302: pac.tax_unit_id tax_uid
303: from per_assignments_f paa,
304: pay_assignment_actions pac,
305: pay_payroll_actions ppa
306: where ppa.business_group_id = c_business_group_id
307: and pac.tax_unit_id = c_legal_entity_id
569: is
570: select /*+ ORDERED USE_NL(paa) */
571: max(paa.action_sequence),
572: to_number(to_char(ppa.effective_date,'MM'))
573: from per_assignments_f paaf,
574: pay_assignment_actions paa,
575: pay_payroll_actions ppa
576: where paaf.person_id = p_person_id
577: and paa.assignment_id = paaf.assignment_id
587: is
588: select /*+ ORDERED USE_NL(paa) */
589: paa.assignment_action_id,
590: ppa.effective_date
591: from per_assignments_f paaf,
592: pay_assignment_actions paa,
593: pay_payroll_actions ppa
594: where paaf.person_id = p_person_id
595: and paa.assignment_id = paaf.assignment_id