APPS.PAY_IN_REPORTS_PKG dependencies on FND_DATE

Line 4517: -- fnd_date.canonical_to_number in --

4513: -- 115.0 10-Mar-2005 aaagarwa Initial Version --
4514: -- 115.1 24-Mar-2005 aaagarwa Modified for remarks handling --
4515: -- 115.2 31-Mar-2005 aaagarwa Added the join for BG id --
4516: -- 115.3 16-Oct-2006 rpalli Bug 5599977: Added conversion factor --
4517: -- fnd_date.canonical_to_number in --
4518: -- cursors c_challan,c_asg_details --
4519: -- 115.4 05-Nov-2007 rsaharay Modified Cursor c_org_contr_days --
4520: -- to calculate No of Days for ESI Wage --
4521: -- correctly in case of Rehire before --

Line 4700: SELECT fnd_date.CANONICAL_TO_DATE(org_information2) challan_date

4696:
4697: --Challan Information
4698: CURSOR c_challan(p_esi_org_id VARCHAR2)
4699: IS
4700: SELECT fnd_date.CANONICAL_TO_DATE(org_information2) challan_date
4701: ,fnd_number.canonical_to_number(org_information3) challan_amt
4702: ,org_information5 challan_bank_code
4703: ,org_information6 challan_branch_code
4704: ,hr_general.decode_lookup('IN_ESI_BANKS',org_information5) challan_bank

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

4706: FROM hr_organization_information
4707: WHERE organization_id=p_esi_org_id
4708: AND ORG_INFORMATION_CONTEXT='PER_IN_ESI_CHALLAN_INFO'
4709: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',ORG_INFORMATION1)=p_contribution_period
4710: ORDER BY fnd_date.CANONICAL_TO_DATE(org_information2) ASC;
4711:
4712: --Declaration Information
4713: CURSOR c_declaration(p_esi_org_id VARCHAR2)
4714: IS