APPS.PAY_IN_EOY_REPORTS dependencies on FND_DATE

Line 671: ((SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date

667: -- Bug # 4506944 : Changed the cursor to include Bank Code instead of Bank Name and Branch,
668: -- Cheque /DD No and Transfer Voucher Number
669: --
670: CURSOR csr_bank_pymt IS
671: ((SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
672: ,hoi_bank.org_information4 Bank
673: ,hoi_challan.org_information3 Voucher_Num
674: ,hoi_challan.org_information11 DD_Cheque_Num
675: FROM hr_organization_information hoi_bank

Line 686: (SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date

682: AND hoi_challan.org_information12 = 'N'
683: AND hoi_challan.org_information1 = to_char(to_number(substr(g_assessment_year, 1,4))-1)||'-'||to_char(to_number(substr(g_assessment_year, 6,4))-1)
684: )
685: UNION ALL
686: (SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
687: ,hoi_challan.org_information5 Bank
688: ,hoi_challan.org_information3 Voucher_Num
689: ,hoi_challan.org_information11 DD_Cheque_Num
690: FROM hr_organization_information hoi_challan

Line 858: , TO_CHAR(fnd_date.canonical_to_date(pai.action_information10),'DD-MM-YYYY') emp_dob_value

854: END emp_designation_value
855: , 'E_FAT_NAME' emp_father_name
856: , UPPER(pai.action_information7) emp_father_value
857: , 'DOB' emp_dob
858: , TO_CHAR(fnd_date.canonical_to_date(pai.action_information10),'DD-MM-YYYY') emp_dob_value
859: , 'GENDER' emp_gender
860: , UPPER(pai.action_information11) emp_gender_value
861: , 'E_INTEREST' emp_interest
862: , DECODE(pai.action_information12,'N','No','Y','Yes') emp_interest_value

Line 945: l_date_earned := fnd_date.canonical_to_date(l_date);

941: l_asg_id := i.emp_asg_id;
942: END LOOP;
943:
944:
945: l_date_earned := fnd_date.canonical_to_date(l_date);
946:
947: OPEN csr_payroll_id(l_asg_id,l_date_earned);
948: FETCH csr_payroll_id INTO l_payroll_id;
949: CLOSE csr_payroll_id;

Line 2400: g_tax_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_assessment_year,1,4)),'DD/MM/YYYY');

2396:
2397: l_emp_count := 0;
2398: g_assessment_year := p_assessment_year;
2399: g_tax_year := (to_number(SUBSTR(g_assessment_year,1,4)) - 1)||'-'||SUBSTR(g_assessment_year,3,2);
2400: g_tax_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_assessment_year,1,4)),'DD/MM/YYYY');
2401: g_tax_start_date := ADD_MONTHS(g_tax_end_date,-12) +1;
2402:
2403:
2404: OPEN csr_global_value('IN_SECTION_80CCE_LIMIT');

Line 2659: g_tax_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_assessment_year,1,4)),'DD/MM/YYYY');

2655:
2656: l_emp_count := 0;
2657: g_assessment_year := p_assessment_year;
2658: g_tax_year := (to_number(SUBSTR(g_assessment_year,1,4)) - 1)||'-'||SUBSTR(g_assessment_year,3,2);
2659: g_tax_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_assessment_year,1,4)),'DD/MM/YYYY');
2660: g_tax_start_date := ADD_MONTHS(g_tax_end_date,-12) +1;
2661:
2662:
2663: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,20);