[Home] [Help]
36: l_last_name per_all_people_f.last_name%TYPE ;
37: l_first_name per_all_people_f.first_name%TYPE ;
38: l_middle_name per_all_people_f.middle_names%TYPE ;
39: l_full_name per_all_people_f.full_name%TYPE ;
40: l_assignment_number per_assignments_f.assignment_number%TYPE ;
41: l_dob per_all_people_f.date_of_birth%TYPE ;
42: --l_payroll_id per_assignments_f.payroll_id%TYPE ;
43: l_legislation_code per_business_groups.legislation_code%TYPE ;
44: l_business_group_id_ct pay_payroll_actions.business_group_id%TYPE :=NULL ;
38: l_middle_name per_all_people_f.middle_names%TYPE ;
39: l_full_name per_all_people_f.full_name%TYPE ;
40: l_assignment_number per_assignments_f.assignment_number%TYPE ;
41: l_dob per_all_people_f.date_of_birth%TYPE ;
42: --l_payroll_id per_assignments_f.payroll_id%TYPE ;
43: l_legislation_code per_business_groups.legislation_code%TYPE ;
44: l_business_group_id_ct pay_payroll_actions.business_group_id%TYPE :=NULL ;
45: l_param_count NUMBER(2):=0 ;
46: l_ppa_finder VARCHAR2(20) ;
53:
54: TYPE r_date_detail IS RECORD (
55: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
56: defined_balance_id pay_defined_balances.defined_balance_id%TYPE,
57: payroll_id per_assignments_f.payroll_id%TYPE,
58: pay_date DATE
59: );
60: TYPE t_date_detail is Table OF r_date_detail
61: INDEX BY binary_integer ;
929: ppv.national_identifier,
930: paf.assignment_number
931: FROM
932: per_all_people_f ppv,
933: per_assignments_f paf
934: WHERE paf.assignment_id=p_assignment
935: AND paf.person_id=ppv.person_id
936: AND l_effective_date BETWEEN ppv.effective_start_date
937: AND ppv.effective_end_date
1015: paa.chunk_number chnkno,
1016: paa.payroll_action_id pactid
1017: FROM
1018: hr_organization_units hou1,
1019: per_assignments_f paf,
1020: pay_payroll_actions ppa,
1021: pay_assignment_actions paa1,
1022: pay_action_interlocks pai,
1023: pay_assignment_actions paa,