142: Also the balance 'RL1 Non Taxable Earnings'
143: is deducted from Gross Earnings.
144: 18-Sep-2003 vpandya 115.50 Archiving dates in canonical format
145: (YYYY/MM/DD HH:MI:SS) using
146: fnd_date.date_to_canonical_to_date
147: instead of using to_char with default
148: format to fix gscc date conversion error.
149: 21-OCT-2003 ssouresr 115.51 Added RL1 Amendment Archiving logic
150: in eoy_archive_data procedure. Also
3808: hr_utility.trace('Before counter 3');
3809: l_counter := l_counter + 1;
3810: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_DATE_OF_BIRTH';
3811: l_user_entity_value_tab(l_counter):=
3812: fnd_date.date_to_canonical(l_date_of_birth);
3813:
3814: hr_utility.trace('Before counter 3');
3815: l_counter := l_counter + 1;
3816: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_HIRE_DATE';
3814: hr_utility.trace('Before counter 3');
3815: l_counter := l_counter + 1;
3816: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_HIRE_DATE';
3817: l_user_entity_value_tab(l_counter):=
3818: fnd_date.date_to_canonical(l_hire_date);
3819:
3820: hr_utility.trace('Before counter 3');
3821: l_counter := l_counter + 1;
3822: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_TERMINATION_DATE';
3820: hr_utility.trace('Before counter 3');
3821: l_counter := l_counter + 1;
3822: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_TERMINATION_DATE';
3823: l_user_entity_value_tab(l_counter):=
3824: fnd_date.date_to_canonical(l_termination_date);
3825:
3826: hr_utility.trace('Before counter 3');
3827: l_counter := l_counter + 1;
3828: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_NUMBER';
3954:
3955: exit when c_get_preprinted_form_no%NOTFOUND;
3956:
3957: if ((lv_fapp_effective_date =
3958: to_char(fnd_date.canonical_to_date(lv_eit_year), 'YYYY')) and
3959: (ln_fapp_pre_org_id = to_number(lv_eit_pre_org_id)) and
3960: (ln_form_no_archived = 'N')) then
3961:
3962: ff_archive_api.create_archive_item(
4098: per_all_assignments_f asg,
4099: pay_payroll_actions ppa1
4100: where ppa1.payroll_action_id = :payroll_action_id
4101: and ppa.effective_date between
4102: fnd_date.canonical_to_date('''||
4103: fnd_date.date_to_canonical(l_year_start)||''') and
4104: fnd_date.canonical_to_date('''||
4105: fnd_date.date_to_canonical(l_year_end)||''')
4106: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4099: pay_payroll_actions ppa1
4100: where ppa1.payroll_action_id = :payroll_action_id
4101: and ppa.effective_date between
4102: fnd_date.canonical_to_date('''||
4103: fnd_date.date_to_canonical(l_year_start)||''') and
4104: fnd_date.canonical_to_date('''||
4105: fnd_date.date_to_canonical(l_year_end)||''')
4106: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4107: and ppa.action_status = ''C''
4100: where ppa1.payroll_action_id = :payroll_action_id
4101: and ppa.effective_date between
4102: fnd_date.canonical_to_date('''||
4103: fnd_date.date_to_canonical(l_year_start)||''') and
4104: fnd_date.canonical_to_date('''||
4105: fnd_date.date_to_canonical(l_year_end)||''')
4106: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4107: and ppa.action_status = ''C''
4108: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
4101: and ppa.effective_date between
4102: fnd_date.canonical_to_date('''||
4103: fnd_date.date_to_canonical(l_year_start)||''') and
4104: fnd_date.canonical_to_date('''||
4105: fnd_date.date_to_canonical(l_year_end)||''')
4106: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4107: and ppa.action_status = ''C''
4108: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
4109: and ppa.payroll_action_id = paa.payroll_action_id