APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 30: employee_name per_all_people_f.per_information1%type ,

26: ----------------------------------------------------------------------
27: --Table to store employee details
28: ----------------------------------------------------------------------
29: type emp_details_store_rec is record (
30: employee_name per_all_people_f.per_information1%type ,
31: employee_number per_all_people_f.employee_number%type ,
32: cpf_number per_all_people_f.per_information14%type,
33: person_id per_all_people_f.person_id%type,
34: telephone_number per_addresses.telephone_number_1%type) ;

Line 31: employee_number per_all_people_f.employee_number%type ,

27: --Table to store employee details
28: ----------------------------------------------------------------------
29: type emp_details_store_rec is record (
30: employee_name per_all_people_f.per_information1%type ,
31: employee_number per_all_people_f.employee_number%type ,
32: cpf_number per_all_people_f.per_information14%type,
33: person_id per_all_people_f.person_id%type,
34: telephone_number per_addresses.telephone_number_1%type) ;
35: --

Line 32: cpf_number per_all_people_f.per_information14%type,

28: ----------------------------------------------------------------------
29: type emp_details_store_rec is record (
30: employee_name per_all_people_f.per_information1%type ,
31: employee_number per_all_people_f.employee_number%type ,
32: cpf_number per_all_people_f.per_information14%type,
33: person_id per_all_people_f.person_id%type,
34: telephone_number per_addresses.telephone_number_1%type) ;
35: --
36: emp_details_rec emp_details_store_rec;

Line 33: person_id per_all_people_f.person_id%type,

29: type emp_details_store_rec is record (
30: employee_name per_all_people_f.per_information1%type ,
31: employee_number per_all_people_f.employee_number%type ,
32: cpf_number per_all_people_f.per_information14%type,
33: person_id per_all_people_f.person_id%type,
34: telephone_number per_addresses.telephone_number_1%type) ;
35: --
36: emp_details_rec emp_details_store_rec;
37: --

Line 94: p_start_person_id in per_all_people_f.person_id%type,

90: -- Assignment Action Code
91: ------------------------------------------------------------
92: procedure assignment_action_code
93: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
94: p_start_person_id in per_all_people_f.person_id%type,
95: p_end_person_id in per_all_people_f.person_id%type,
96: p_chunk in number )
97: is
98: l_proc_name varchar2(100) ;

Line 95: p_end_person_id in per_all_people_f.person_id%type,

91: ------------------------------------------------------------
92: procedure assignment_action_code
93: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
94: p_start_person_id in per_all_people_f.person_id%type,
95: p_end_person_id in per_all_people_f.person_id%type,
96: p_chunk in number )
97: is
98: l_proc_name varchar2(100) ;
99: l_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 232: l_person_id per_all_people_f.person_id%type;

228: g_context_tab pay_balance_pkg.t_context_tab;
229: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
230: --
231: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
232: l_person_id per_all_people_f.person_id%type;
233: l_cpf_tot_earn_cap_amt ff_globals_f.global_value%type;
234: l_aw_toward_cap number;
235: l_aw_cap_recalculated number;
236: l_master_block char(1);

Line 271: cursor month_year_action_sequence ( c_person_id per_all_people_f.person_id%type,

267: select max(people1.effective_start_date)
268: from per_people_f people1
269: where people1.person_id = pap.person_id);
270: --
271: cursor month_year_action_sequence ( c_person_id per_all_people_f.person_id%type,
272: c_business_group_id hr_organization_units.business_group_id%type,
273: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
274: c_basis_year varchar2 )
275: is

Line 293: cursor month_year_action ( c_person_id per_all_people_f.person_id%type,

289: and ppamax.action_type in ('R','B','I','Q','V')
290: group by to_char(ppamax.effective_date,'MM')
291: order by to_char(ppamax.effective_date,'MM') desc;
292: --
293: cursor month_year_action ( c_person_id per_all_people_f.person_id%type,
294: c_business_group_id hr_organization_units.business_group_id%type,
295: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
296: c_basis_year varchar2,
297: c_action_sequence pay_assignment_actions.action_sequence%type )

Line 565: function get_cur_year_ord_ytd (p_person_id in per_all_people_f.person_id%type,

561: end archive_code ;
562: ----------------------------------------------------------------------------------
563: --Function calculates current year Ordinary Earnings with monthly ceiling of 5,500
564: ---------------------------------------------------------------------------------
565: function get_cur_year_ord_ytd (p_person_id in per_all_people_f.person_id%type,
566: p_assignment_id in per_all_assignments_f.assignment_id%type,
567: p_date_earned in date) return number
568: is
569: l_proc_name varchar2(100);