APPS.PAY_IN_EOY_REPORTS dependencies on FND_DATE

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

533: -- Bug # 4506944 : Changed the cursor to include Bank Code instead of Bank Name and Branch,
534: -- Cheque /DD No and Transfer Voucher Number
535: --
536: CURSOR csr_bank_pymt IS
537: ((SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
538: ,hoi_bank.org_information4 Bank
539: ,hoi_challan.org_information3 Voucher_Num
540: ,hoi_challan.org_information11 DD_Cheque_Num
541: FROM hr_organization_information hoi_bank

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

548: AND hoi_challan.org_information12 = 'N'
549: 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)
550: )
551: UNION ALL
552: (SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
553: ,hoi_challan.org_information5 Bank
554: ,hoi_challan.org_information3 Voucher_Num
555: ,hoi_challan.org_information11 DD_Cheque_Num
556: FROM hr_organization_information hoi_challan

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

564:
565: --Cursor to get challan details for Form16 AA
566:
567: CURSOR csr_bank_pymt_16aa IS
568: ((SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
569: ,hr_general.decode_lookup('IN_BANK',hoi_bank.org_information1)||','||hr_general.decode_lookup('IN_BANK_BRANCH',hoi_bank.org_information2) Bank
570: ,hoi_challan.org_information3 Voucher_Num
571: FROM hr_organization_information hoi_bank
572: ,hr_organization_information hoi_challan

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

578: AND hoi_challan.org_information12 = 'N'
579: 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)
580: )
581: UNION ALL
582: (SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
583: ,hoi_challan.org_information5 Bank
584: ,hoi_challan.org_information3 Voucher_Num
585: FROM hr_organization_information hoi_challan
586: WHERE hoi_challan.organization_id = p_gre_id

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

740: , UPPER(pai.action_information9) emp_designation_value
741: , 'E_FAT_NAME' emp_father_name
742: , UPPER(pai.action_information7) emp_father_value
743: , 'DOB' emp_dob
744: , TO_CHAR(fnd_date.canonical_to_date(pai.action_information10),'DD-MM-YYYY') emp_dob_value
745: , 'GENDER' emp_gender
746: , UPPER(pai.action_information11) emp_gender_value
747: , 'E_INTEREST' emp_interest
748: , DECODE(pai.action_information12,'N','No','Y','Yes') emp_interest_value

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

820: l_resident_status := i.emp_resident_status;
821: l_asg_id := i.emp_asg_id;
822: END LOOP;
823:
824: l_date_earned := fnd_date.canonical_to_date(l_date);
825:
826: OPEN csr_payroll_id(l_asg_id,l_date_earned);
827: FETCH csr_payroll_id INTO l_payroll_id;
828: CLOSE csr_payroll_id;

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

2091:
2092: l_emp_count := 0;
2093: g_assessment_year := p_assessment_year;
2094: g_tax_year := (to_number(SUBSTR(g_assessment_year,1,4)) - 1)||'-'||SUBSTR(g_assessment_year,3,2);
2095: g_tax_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_assessment_year,1,4)),'DD/MM/YYYY');
2096: g_tax_start_date := ADD_MONTHS(g_tax_end_date,-12) +1;
2097:
2098:
2099: