[Home] [Help]
896: assact_job_id number,
897: assact_payroll_id number,
898: assact_location_id number,
899: assact_termination_date date,
900: assact_leaving_reason per_periods_of_service.leaving_reason%type,
901: emp_person_id number,
902: emp_employee_number per_all_people_f.employee_number%type,
903: emp_last_name per_all_people_f.per_information18%type,
904: emp_first_name per_all_people_f.per_information19%type,
6031: p_sqlstr :=
6032: 'select distinct ppos.person_id
6033: from pay_payroll_actions ppa,
6034: per_all_people_f pp,
6035: per_periods_of_service ppos
6036: where ppa.payroll_action_id = :payroll_action_id
6037: and pp.business_group_id = ppa.business_group_id + 0
6038: and ppos.person_id = pp.person_id
6039: and ppos.business_group_id + 0 = pp.business_group_id
7615: -- and paa2.action_sequence > paa.action_sequence) */
7616: ) proc_v,
7617: per_all_assignments_f pa,
7618: per_all_people_f pp,
7619: per_periods_of_service ppos,
7620: pay_all_payrolls_f ppy
7621: where pa.assignment_id = proc_v.assignment_id
7622: and proc_v.effective_date
7623: between pa.effective_start_date and pa.effective_end_date
8128: -- and paa2.action_sequence > paa.action_sequence) */
8129: ) proc_v,
8130: per_all_assignments_f pa,
8131: per_all_people_f pp,
8132: per_periods_of_service ppos,
8133: pay_all_payrolls_f ppy
8134: where pa.assignment_id = proc_v.assignment_id
8135: and proc_v.effective_date
8136: between pa.effective_start_date and pa.effective_end_date
8227: pp.sex,
8228: pp.date_of_birth
8229: from per_all_assignments_f pa,
8230: per_all_people_f pp,
8231: per_periods_of_service ppos
8232: where pa.assignment_id = p_assignment_id
8233: and p_effective_date
8234: between pa.effective_start_date and pa.effective_end_date
8235: and pp.person_id = pa.person_id