APPS.PAY_IN_REPORTS_PKG dependencies on FND_DATE

Line 5236: -- fnd_date.canonical_to_number in --

5232: -- 115.0 10-Mar-2005 aaagarwa Initial Version --
5233: -- 115.1 24-Mar-2005 aaagarwa Modified for remarks handling --
5234: -- 115.2 31-Mar-2005 aaagarwa Added the join for BG id --
5235: -- 115.3 16-Oct-2006 rpalli Bug 5599977: Added conversion factor --
5236: -- fnd_date.canonical_to_number in --
5237: -- cursors c_challan,c_asg_details --
5238: -- 115.4 05-Nov-2007 rsaharay Modified Cursor c_org_contr_days --
5239: -- to calculate No of Days for ESI Wage --
5240: -- correctly in case of Rehire before --

Line 5419: SELECT fnd_date.CANONICAL_TO_DATE(org_information2) challan_date

5415:
5416: --Challan Information
5417: CURSOR c_challan(p_esi_org_id VARCHAR2)
5418: IS
5419: SELECT fnd_date.CANONICAL_TO_DATE(org_information2) challan_date
5420: ,fnd_number.canonical_to_number(org_information3) challan_amt
5421: ,org_information5 challan_bank_code
5422: ,org_information6 challan_branch_code
5423: ,hr_general.decode_lookup('IN_ESI_BANKS',org_information5) challan_bank

Line 5429: ORDER BY fnd_date.CANONICAL_TO_DATE(org_information2) ASC;

5425: FROM hr_organization_information
5426: WHERE organization_id=p_esi_org_id
5427: AND ORG_INFORMATION_CONTEXT='PER_IN_ESI_CHALLAN_INFO'
5428: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',ORG_INFORMATION1)=p_contribution_period
5429: ORDER BY fnd_date.CANONICAL_TO_DATE(org_information2) ASC;
5430:
5431: --Declaration Information
5432: CURSOR c_declaration(p_esi_org_id VARCHAR2)
5433: IS