APPS.PQP_NL_PGGM_FUNCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 174: FROM hr_organization_information

170: --
171: CURSOR c_get_contrib_frm_org(c_org_id IN NUMBER) IS
172: SELECT decode(p_ee_or_total,0,nvl(fnd_number.canonical_to_number(org_information4),0)
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)

Line 1063: FROM hr_organization_information

1059: -- Code 1 => End Of Year Bonus Percentage
1060: --
1061: CURSOR c_get_general_info(c_org_id IN NUMBER) IS
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)))

Line 1072: l_value hr_organization_information.org_information1%TYPE;

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;
1072: l_value hr_organization_information.org_information1%TYPE;
1073: l_loop_again NUMBER := 1;
1074: l_version_id NUMBER;
1075:
1076: BEGIN