APPS.PAY_AU_RECON_SUMMARY dependencies on PER_ALL_PEOPLE_F

Line 1548: l_current_employee_flag per_all_people_f.current_employee_flag%type;

1544: l_post30jun1983_value NUMBER;
1545: l_result NUMBER;
1546: l_etp_service_date date; /* Bug# 2984390 */
1547: l_le_etp_service_date date; /* Bug 4177679 */
1548: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1549: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1550: l_date_start per_periods_of_service.date_start%TYPE;
1551: l_death_benefit_type varchar2(100);
1552: l_lst_yr_start date;

Line 1566: from per_all_people_f p,

1562: SELECT distinct nvl(current_employee_flag,'N') current_employee_flag
1563: ,actual_termination_date
1564: ,date_start
1565: ,pps.pds_information2
1566: from per_all_people_f p,
1567: per_all_assignments_f a,
1568: per_periods_of_service pps
1569: where a.person_id = p.person_id
1570: and pps.person_id = p.person_id

Line 1576: from per_all_people_f pp

1572: and ( pps.actual_termination_date between c_lst_year_start --bug 3686549
1573: and c_year_end ) --Bug 3263659
1574: and a.assignment_id = c_assignment_id
1575: and p.effective_start_date = (SELECT max(pp.effective_start_date)
1576: from per_all_people_f pp
1577: where p.person_id = pp.person_id )
1578: and a.effective_start_date = (SELECT max(aa.effective_start_date)
1579: from per_all_assignments_f aa
1580: where aa.assignment_id = c_assignment_id); /*Bug 4256486 */

Line 2300: from per_all_people_f pap,per_all_assignments_f paa

2296: c_financial_yr_end date)
2297: is
2298: SELECT pap.last_name,
2299: paa.assignment_number
2300: from per_all_people_f pap,per_all_assignments_f paa
2301: where pap.person_id=paa.person_id
2302: and paa.assignment_id=c_assignment_id
2303: and paa.effective_start_date = (SELECT max(paa1.effective_start_date)
2304: from per_all_assignments_f paa1

Line 2307: from per_all_people_f ppf

2303: and paa.effective_start_date = (SELECT max(paa1.effective_start_date)
2304: from per_all_assignments_f paa1
2305: where paa1.assignment_id = c_assignment_id) /* Bug 4278407*/
2306: and pap.effective_start_date = (SELECT max(ppf.effective_start_date)
2307: from per_all_people_f ppf
2308: where pap.person_id = ppf.person_id);
2309:
2310: CURSOR c_eit_updated(c_assignment_id per_all_assignments_f.assignment_id%type,
2311: c_financial_year varchar2)

Line 2329: l_employee_name per_all_people_f.last_name%type;

2325: If the Manual PS is issued for 'All' the legal employers the aei_information2 would be -999*/
2326:
2327: l_assignment_id per_all_assignments_f.assignment_id%type;
2328: l_assignment_number per_all_assignments_f.assignment_number%type;
2329: l_employee_name per_all_people_f.last_name%type;
2330: l_reason fnd_new_messages.message_text%type;
2331:
2332:
2333: begin

Line 2922: p_start_person_id in per_all_people_f.person_id%type,

2918: -- Which are then used in main report query to get assignment_ids
2919: --------------------------------------------------------------------
2920: procedure assignment_action_code
2921: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2922: p_start_person_id in per_all_people_f.person_id%type,
2923: p_end_person_id in per_all_people_f.person_id%type,
2924: p_chunk in number) is
2925:
2926:

Line 2923: p_end_person_id in per_all_people_f.person_id%type,

2919: --------------------------------------------------------------------
2920: procedure assignment_action_code
2921: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2922: p_start_person_id in per_all_people_f.person_id%type,
2923: p_end_person_id in per_all_people_f.person_id%type,
2924: p_chunk in number) is
2925:
2926:
2927: l_asgid per_assignments_f.assignment_id%type;