[Home] [Help]
37: l_last_name per_all_people_f.last_name%TYPE ;
38: l_first_name per_all_people_f.first_name%TYPE ;
39: l_middle_name per_all_people_f.middle_names%TYPE ;
40: l_full_name per_all_people_f.full_name%TYPE ;
41: l_assignment_number per_assignments_f.assignment_number%TYPE ;
42: l_dob per_all_people_f.date_of_birth%TYPE ;
43: --l_payroll_id per_assignments_f.payroll_id%TYPE ;
44: l_legislation_code per_business_groups.legislation_code%TYPE ;
45: l_business_group_id_ct pay_payroll_actions.business_group_id%TYPE :=NULL ;
39: l_middle_name per_all_people_f.middle_names%TYPE ;
40: l_full_name per_all_people_f.full_name%TYPE ;
41: l_assignment_number per_assignments_f.assignment_number%TYPE ;
42: l_dob per_all_people_f.date_of_birth%TYPE ;
43: --l_payroll_id per_assignments_f.payroll_id%TYPE ;
44: l_legislation_code per_business_groups.legislation_code%TYPE ;
45: l_business_group_id_ct pay_payroll_actions.business_group_id%TYPE :=NULL ;
46: l_param_count NUMBER(2):=0 ;
47: l_ppa_finder VARCHAR2(20) ;
54:
55: TYPE r_date_detail IS RECORD (
56: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
57: defined_balance_id pay_defined_balances.defined_balance_id%TYPE,
58: payroll_id per_assignments_f.payroll_id%TYPE,
59: pay_date DATE
60: );
61: TYPE t_date_detail is Table OF r_date_detail
62: INDEX BY binary_integer ;
1107: ppv.national_identifier,
1108: paf.assignment_number
1109: FROM
1110: per_all_people_f ppv,
1111: per_assignments_f paf
1112: WHERE paf.assignment_id=p_assignment
1113: AND paf.person_id=ppv.person_id
1114: AND l_effective_date BETWEEN ppv.effective_start_date
1115: AND ppv.effective_end_date
1193: paa.chunk_number chnkno,
1194: paa.payroll_action_id pactid
1195: FROM
1196: hr_organization_units hou1,
1197: per_assignments_f paf,
1198: pay_payroll_actions ppa,
1199: pay_assignment_actions paa1,
1200: pay_action_interlocks pai,
1201: pay_assignment_actions paa,