[Home] [Help]
103: 13-Feb-2009 krreddy 115.39 8216080 Modified the code to implement P46Expat Notification
104: 26-Mar-2009 dwkrishn 115.40 8315067 Modified characterset for Job Title from FULL_EDI to P14_FULL_EDI
105: 25-Jun-2009 dwkrishn 115.41 8609586 Modified characterset for address from EDI_SURNAME to P14_FULL_EDI
106: 09-Jul-2009 dwkrishn 115.42 8609586 Modified characterset for employer address from FULL_EDI to P14_FULL_EDI
107: 22-Jul-2009 rlingama 115.43 8574855 Added hint PER_ASSIGNMENTS_F_N12 in csr_asg cursor for tuning the query.
108: 31-Jul-2009 namgoyal 115.44 8704601 Modified date_validate logic for P46_CAR
109: 10-Aug-2009 namgoyal 115.45 8704601 Modified date_validate logic for P46_CAR
110: 10-Aug-2009 namgoyal 115.46 8830306 Added Logic to display P46 ( MOVDED 6.0 ) in output file
111: 22-Jan-2010 namgoyal 115.47 9255173,9255183 Updated for P46 V6 and P46 Expat eText reports
355: business_group_id
356: from pay_payroll_actions
357: where payroll_action_id = pactid;
358:
359: -- Bug 8574855 : Added hint PER_ASSIGNMENTS_F_N12 for tuning the query.
360: cursor csr_asg is
361: select /*+ ordered index(ASG PER_ASSIGNMENTS_F_N12) */ asg.assignment_id
362: from per_all_people_f pap,
363: per_assignments_f asg,
357: where payroll_action_id = pactid;
358:
359: -- Bug 8574855 : Added hint PER_ASSIGNMENTS_F_N12 for tuning the query.
360: cursor csr_asg is
361: select /*+ ordered index(ASG PER_ASSIGNMENTS_F_N12) */ asg.assignment_id
362: from per_all_people_f pap,
363: per_assignments_f asg,
364: per_periods_of_service serv,
365: pay_all_payrolls_f pay,
359: -- Bug 8574855 : Added hint PER_ASSIGNMENTS_F_N12 for tuning the query.
360: cursor csr_asg is
361: select /*+ ordered index(ASG PER_ASSIGNMENTS_F_N12) */ asg.assignment_id
362: from per_all_people_f pap,
363: per_assignments_f asg,
364: per_periods_of_service serv,
365: pay_all_payrolls_f pay,
366: hr_soft_coding_keyflex sck
367: where pap.person_id between stperson and endperson
816: asg.assignment_id,
817: asg.effective_start_date,
818: asg.effective_end_date
819: from pay_assignment_actions paa,
820: per_assignments_f asg
821: where paa.assignment_action_id = p_assactid
822: and paa.assignment_id = asg.assignment_id
823: and p_effective_date between asg.effective_start_date and asg.effective_end_date;
824:
1098: pap.sex,
1099: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
1100: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
1101: from pay_assignment_actions act,
1102: per_assignments_f paa,
1103: per_people_f pap,
1104: per_periods_of_service serv
1105: where act.assignment_action_id = p_assactid
1106: and act.assignment_id = paa.assignment_id
1112:
1113: cursor csr_job is
1114: select pay_get_job_segment_pkg.get_job_segment(paa.business_group_id,job.job_definition_id,act.payroll_action_id) job
1115: from pay_assignment_actions act,
1116: per_assignments_f paa,
1117: per_jobs job
1118: where act.assignment_action_id = p_assactid
1119: and act.assignment_id = paa.assignment_id
1120: and paa.job_id = job.job_id(+)
1578: l_action_id number;
1579: --edi_validation_fail varchar2(50);
1580:
1581: l_sex per_people_f.sex%TYPE;
1582: l_assignment_number per_assignments_f.assignment_number%TYPE;
1583: l_date_of_birth varchar2(100);
1584: l_tax_code_in_use varchar2(100);
1585: l_tax_basis_in_use varchar2(100);
1586: l_msg_value varchar2(100);
1705: --edi_validation_fail varchar2(50);
1706:
1707:
1708: l_national_insurance_number per_people_f.national_identifier%TYPE;
1709: l_assignment_number per_assignments_f.assignment_number%TYPE;
1710: l_address_line1 per_addresses.address_line1%TYPE;
1711: l_address_line2 per_addresses.address_line2%TYPE;
1712: l_address_line3 per_addresses.address_line3%TYPE;
1713: l_address_line4 per_addresses.address_line3%TYPE;
2683: l_proc CONSTANT VARCHAR2(50):= g_package||'p46_v6_asg_etext_vals';
2684: l_err BOOLEAN := False;
2685:
2686: l_tax_code_in_use VARCHAR2(50);
2687: l_assignment_number per_assignments_f.assignment_number%TYPE;
2688: l_sex per_people_f.sex%TYPE;
2689: l_date_of_birth VARCHAR2(100);
2690: l_hire_date VARCHAR2(100);
2691: l_tax_basis_in_use VARCHAR2(50);