APPS.PAY_AE_SI_REPORTS dependencies on FND_DATE

Line 167: SELECT ppf.full_name,ppf.employee_number,ppf.date_of_birth,ppf.marital_status,ppf.sex,fnd_date.canonical_to_date(ppf.per_information16),ppf.per_information17

163: AND ppf.per_information18 = l_nat_cd;
164:
165: /* Cursor for fetching the person data */
166: CURSOR csr_p_data (l_person_id number,l_effective_date date) IS
167: SELECT ppf.full_name,ppf.employee_number,ppf.date_of_birth,ppf.marital_status,ppf.sex,fnd_date.canonical_to_date(ppf.per_information16),ppf.per_information17
168: FROM per_all_people_f ppf
169: WHERE ppf.person_id = l_person_id
170: AND l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
171:

Line 190: SELECT hsck.segment2,hsck.segment3,fnd_date.canonical_to_date(hsck.segment4),hsck.segment5,paf.location_id

186: AND hl.enabled_flag = 'Y';
187:
188: /* Cursor for fetching the person's assignment data */
189: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
190: SELECT hsck.segment2,hsck.segment3,fnd_date.canonical_to_date(hsck.segment4),hsck.segment5,paf.location_id
191: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck
192: WHERE paf.person_id = l_person_id
193: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
194: AND hsck.segment1 = p_employer_id

Line 227: SELECT pr.employer_name ,pr.previous_employer_id,pr.employer_type, pr.PEM_INFORMATION1 , fnd_date.canonical_to_date(pr.PEM_INFORMATION2),pr.PEM_INFORMATION3,pr.PEM_INFORMATION4

223: and est.establishment_id = pea.establishment_id;
224:
225: /* Cursor for fetching the person's ex-employer's name */
226: CURSOR csr_p_ex_emp_data (l_person_id number) IS
227: SELECT pr.employer_name ,pr.previous_employer_id,pr.employer_type, pr.PEM_INFORMATION1 , fnd_date.canonical_to_date(pr.PEM_INFORMATION2),pr.PEM_INFORMATION3,pr.PEM_INFORMATION4
228: FROM per_previous_employers pr
229: WHERE pr.person_id = l_person_id
230: AND pr.PEM_INFORMATION_CATEGORY ='AE'
231: AND nvl(pr.end_date,sysdate) in (SELECT nvl(max(end_date),sysdate)

Line 2956: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));

2952: CLOSE csr_get_si_id;
2953:
2954: /* Fetch values for Social insurance contribution values for Employer */
2955: /* Set the contexts for date earned as effective date*/
2956: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
2957: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2958: l_cur_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2959: l_cur_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2960: l_cur_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);

Line 2965: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(add_months(l_effective_date,-1)));

2961: l_cur_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2962: l_cur_total := l_cur_si_er + l_cur_si_er_adj + l_cur_si_ee + l_cur_si_ee_adj;
2963:
2964: /* Set the contexts for date earned as previous month*/
2965: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(add_months(l_effective_date,-1)));
2966: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2967: l_prev_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2968: l_prev_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2969: l_prev_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);

Line 4175: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));

4171: ELSE
4172: l_allowance_3_val := 0;
4173: END IF;
4174:
4175: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));
4176: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);
4177:
4178: l_ee_si_val := pay_balance_pkg.get_value(l_ee_soc_ins_id,t_store_assact(j).assignment_action_id);
4179: l_er_si_val := pay_balance_pkg.get_value(l_er_soc_ins_id,t_store_assact(j).assignment_action_id);

Line 4911: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));

4907: END;
4908:
4909:
4910: /* Fetch balance values for Employee SI Contribution and Employer SI Contribution */
4911: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));
4912: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);
4913:
4914: OPEN csr_def_bal_id('EMPLOYEE_SOCIAL_INSURANCE_ADJUSTMENT_ASG_RUN');
4915: FETCH csr_def_bal_id INTO l_defined_balance_id;