APPS.PQP_NL_PGGM_FUNCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 162: FROM hr_organization_information

158: --
159: CURSOR c_get_contrib_frm_org(c_org_id IN NUMBER) IS
160: SELECT decode(p_ee_or_total,0,nvl(fnd_number.canonical_to_number(org_information4),0)
161: ,nvl(fnd_number.canonical_to_number(org_information5),0))
162: FROM hr_organization_information
163: WHERE org_information_context = 'PQP_NL_PGGM_PT'
164: AND organization_id = c_org_id
165: AND p_date_earned BETWEEN fnd_date.canonical_to_date(org_information1)
166: AND nvl(fnd_date.canonical_to_date(org_information2),hr_api.g_eot)

Line 909: FROM hr_organization_information

905: -- Code 1 => End Of Year Bonus Percentage
906: --
907: CURSOR c_get_general_info(c_org_id IN NUMBER) IS
908: SELECT decode(p_code,0,org_information3,1,org_information4)
909: FROM hr_organization_information
910: WHERE organization_id = c_org_id
911: AND org_information_context = 'PQP_NL_PGGM_INFO'
912: AND p_date_earned BETWEEN fnd_date.canonical_to_date(org_information1)
913: AND fnd_date.canonical_to_date(nvl(org_information2,fnd_date.date_to_canonical(hr_api.g_eot)))

Line 918: l_value hr_organization_information.org_information1%TYPE;

914: AND decode(p_code,0,org_information3,1,org_information4) IS NOT NULL;
915:
916: l_proc_name VARCHAR2(30) := 'GET_GENERAL_INFO';
917: l_org_id NUMBER;
918: l_value hr_organization_information.org_information1%TYPE;
919: l_loop_again NUMBER := 1;
920: l_version_id NUMBER;
921:
922: BEGIN