[Home] [Help]
132:
133: CURSOR c_person_details(p_assignment_id number) IS
134: SELECT papf.full_name, papf.email_address, papf.person_id FROM
135: per_all_people_f papf,
136: per_all_assignments_f paaf
137: WHERE
138: papf.person_id=paaf.person_id
139: AND paaf.assignment_id = p_assignment_id
140: AND l_prp_end_date BETWEEN
199: order by action_context_id desc;-- LAtest archive data in that period
200:
201: --Summary Info
202: cursor c_summary_details(p_assignment_id number) is
203: select assignment_number,full_name from per_all_people_f papf,per_all_assignments_f paaf
204: where papf.person_id = paaf.person_id
205: and paaf.assignment_id = p_assignment_id
206: and l_prp_end_date between papf.effective_start_date and papf.effective_end_date
207: and l_prp_end_date between paaf.effective_start_date and paaf.effective_end_date;
1163:
1164: CURSOR c_all_assignments_payroll IS
1165: SELECT DISTINCT
1166: paaf.assignment_id
1167: FROM per_all_assignments_f paaf
1168: , per_assignment_status_types past
1169: WHERE paaf.payroll_id = p_payroll
1170: AND paaf.assignment_status_type_id = past.assignment_status_type_id
1171: AND past.per_system_status = 'ACTIVE_ASSIGN'
1181: t_string VARCHAR2(32767) := NULL;
1182: l_xml CLOB;
1183: EOL VARCHAR2(5) := fnd_global.local_chr(10);
1184: l_req_id varchar2(20);
1185: l_assignment_number per_all_assignments_f.assignment_number%type;
1186: l_employee_name per_all_people_f.full_name%type;
1187: /*
1188:
1189: t_string VARCHAR2(32767) := NULL;
1684:
1685: CURSOR c_all_assignments_payroll IS
1686: SELECT DISTINCT
1687: paaf.assignment_id
1688: FROM per_all_assignments_f paaf
1689: , per_assignment_status_types past
1690: WHERE paaf.payroll_id = p_payroll
1691: AND paaf.assignment_status_type_id = past.assignment_status_type_id
1692: AND past.per_system_status = 'ACTIVE_ASSIGN'