APPS.PAY_AU_RECON_SUMMARY dependencies on PER_ALL_PEOPLE_F

Line 896: l_current_employee_flag per_all_people_f.current_employee_flag%type;

892: l_post30jun1983_value NUMBER;
893: l_result NUMBER;
894: l_etp_service_date date; /* Bug# 2984390 */
895: l_le_etp_service_date date; /* Bug 4177679 */
896: l_current_employee_flag per_all_people_f.current_employee_flag%type;
897: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
898: l_date_start per_periods_of_service.date_start%TYPE;
899: l_death_benefit_type varchar2(100);
900: l_lst_yr_start date;

Line 912: from per_all_people_f p,

908: SELECT distinct nvl(current_employee_flag,'N') current_employee_flag
909: ,actual_termination_date
910: ,date_start
911: ,pps.pds_information2
912: from per_all_people_f p,
913: per_all_assignments_f a,
914: per_periods_of_service pps
915: where a.person_id = p.person_id
916: and pps.person_id = p.person_id

Line 922: from per_all_people_f pp

918: and ( pps.actual_termination_date between c_lst_year_start --bug 3686549
919: and c_year_end ) --Bug 3263659
920: and a.assignment_id = c_assignment_id
921: and p.effective_start_date = (SELECT max(pp.effective_start_date)
922: from per_all_people_f pp
923: where p.person_id = pp.person_id )
924: and a.effective_start_date = (SELECT max(aa.effective_start_date)
925: from per_all_assignments_f aa
926: where aa.assignment_id = c_assignment_id); /*Bug 4256486 */

Line 1235: from per_all_people_f pap,per_all_assignments_f paa

1231: c_financial_yr_end date)
1232: is
1233: SELECT pap.last_name,
1234: paa.assignment_number
1235: from per_all_people_f pap,per_all_assignments_f paa
1236: where pap.person_id=paa.person_id
1237: and paa.assignment_id=c_assignment_id
1238: and paa.effective_start_date = (SELECT max(paa1.effective_start_date)
1239: from per_all_assignments_f paa1

Line 1242: from per_all_people_f ppf

1238: and paa.effective_start_date = (SELECT max(paa1.effective_start_date)
1239: from per_all_assignments_f paa1
1240: where paa1.assignment_id = c_assignment_id) /* Bug 4278407*/
1241: and pap.effective_start_date = (SELECT max(ppf.effective_start_date)
1242: from per_all_people_f ppf
1243: where pap.person_id = ppf.person_id);
1244:
1245: CURSOR c_eit_updated(c_assignment_id per_all_assignments_f.assignment_id%type,
1246: c_financial_year varchar2)

Line 1264: l_employee_name per_all_people_f.last_name%type;

1260: If the Manual PS is issued for 'All' the legal employers the aei_information2 would be -999*/
1261:
1262: l_assignment_id per_all_assignments_f.assignment_id%type;
1263: l_assignment_number per_all_assignments_f.assignment_number%type;
1264: l_employee_name per_all_people_f.last_name%type;
1265: l_reason fnd_new_messages.message_text%type;
1266:
1267:
1268: begin

Line 1706: p_start_person_id in per_all_people_f.person_id%type,

1702: -- Which are then used in main report query to get assignment_ids
1703: --------------------------------------------------------------------
1704: procedure assignment_action_code
1705: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1706: p_start_person_id in per_all_people_f.person_id%type,
1707: p_end_person_id in per_all_people_f.person_id%type,
1708: p_chunk in number) is
1709:
1710:

Line 1707: p_end_person_id in per_all_people_f.person_id%type,

1703: --------------------------------------------------------------------
1704: procedure assignment_action_code
1705: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1706: p_start_person_id in per_all_people_f.person_id%type,
1707: p_end_person_id in per_all_people_f.person_id%type,
1708: p_chunk in number) is
1709:
1710:
1711: l_asgid per_assignments_f.assignment_id%type;