APPS.PQP_NL_PGGM_FUNCTIONS dependencies on FND_DATE

Line 177: AND p_date_earned BETWEEN fnd_date.canonical_to_date(org_information1)

173: ,nvl(fnd_number.canonical_to_number(org_information5),0))
174: FROM hr_organization_information
175: WHERE org_information_context = 'PQP_NL_PGGM_PT'
176: AND organization_id = c_org_id
177: AND p_date_earned BETWEEN fnd_date.canonical_to_date(org_information1)
178: AND nvl(fnd_date.canonical_to_date(org_information2),hr_api.g_eot)
179: AND fnd_number.canonical_to_number(org_information3) = p_pension_type_id;
180:
181: --

Line 178: AND nvl(fnd_date.canonical_to_date(org_information2),hr_api.g_eot)

174: FROM hr_organization_information
175: WHERE org_information_context = 'PQP_NL_PGGM_PT'
176: AND organization_id = c_org_id
177: AND p_date_earned BETWEEN fnd_date.canonical_to_date(org_information1)
178: AND nvl(fnd_date.canonical_to_date(org_information2),hr_api.g_eot)
179: AND fnd_number.canonical_to_number(org_information3) = p_pension_type_id;
180:
181: --
182: -- Cursor to get the percentage value from the pension types table

Line 1066: AND p_date_earned BETWEEN fnd_date.canonical_to_date(org_information1)

1062: SELECT decode(p_code,0,org_information3,1,org_information4)
1063: FROM hr_organization_information
1064: WHERE organization_id = c_org_id
1065: AND org_information_context = 'PQP_NL_PGGM_INFO'
1066: AND p_date_earned BETWEEN fnd_date.canonical_to_date(org_information1)
1067: AND fnd_date.canonical_to_date(nvl(org_information2,fnd_date.date_to_canonical(hr_api.g_eot)))
1068: AND decode(p_code,0,org_information3,1,org_information4) IS NOT NULL;
1069:
1070: l_proc_name VARCHAR2(30) := 'GET_GENERAL_INFO';

Line 1067: AND fnd_date.canonical_to_date(nvl(org_information2,fnd_date.date_to_canonical(hr_api.g_eot)))

1063: FROM hr_organization_information
1064: WHERE organization_id = c_org_id
1065: AND org_information_context = 'PQP_NL_PGGM_INFO'
1066: AND p_date_earned BETWEEN fnd_date.canonical_to_date(org_information1)
1067: AND fnd_date.canonical_to_date(nvl(org_information2,fnd_date.date_to_canonical(hr_api.g_eot)))
1068: AND decode(p_code,0,org_information3,1,org_information4) IS NOT NULL;
1069:
1070: l_proc_name VARCHAR2(30) := 'GET_GENERAL_INFO';
1071: l_org_id NUMBER;