APPS.PQP_NL_ABP_FUNCTIONS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4902: l_org_id hr_all_organization_units.organization_id%TYPE;

4898: ,p_er_contrib_value OUT NOCOPY NUMBER
4899: )
4900: RETURN NUMBER IS
4901:
4902: l_org_id hr_all_organization_units.organization_id%TYPE;
4903: l_payroll_id NUMBER;
4904: l_legal_er_org_id NUMBER;
4905: l_ret_value NUMBER := 0;
4906: l_asg_ret_value NUMBER := 0;

Line 5528: l_org_id hr_all_organization_units.organization_id%type;

5524: ,p_start_date out NOCOPY date
5525: )
5526: RETURN number IS
5527:
5528: l_org_id hr_all_organization_units.organization_id%type;
5529: l_ret_value number := 0; --return
5530: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
5531: l_org_info_id hr_organization_information.org_information_id%type;
5532: l_named_hierarchy number;

Line 5589: CURSOR c_get_valid_org_info(c_org_id in hr_all_organization_units.organization_id%type) IS

5585: and paei.assignment_id = p_assignment_id;
5586:
5587: --Cursor to find if there is any information record at the org level
5588: --if so return the org info id
5589: CURSOR c_get_valid_org_info(c_org_id in hr_all_organization_units.organization_id%type) IS
5590: Select hoi.org_information_id
5591: from hr_organization_information hoi
5592: where hoi.org_information_context = 'PQP_NL_ABP_PT'
5593: and hoi.org_information3 = to_char(p_pension_type_id)

Line 5737: l_org_id hr_all_organization_units.organization_id%type;

5733: ,p_org_id out NOCOPY number
5734: )
5735: IS
5736:
5737: l_org_id hr_all_organization_units.organization_id%type;
5738: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
5739: l_org_info_id hr_organization_information.org_information_id%type;
5740: l_named_hierarchy number;
5741: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;

Line 5800: CURSOR c_get_valid_org_info(c_org_id in hr_all_organization_units.organization_id%type) IS

5796: and trunc(to_date(substr(nvl(paei.aei_information2,'4712/12/31'),1,10),'YYYY/MM/DD'));
5797:
5798: --Cursor to find if the information record at the org level is valid
5799: --on the date earned and if so return the org info id
5800: CURSOR c_get_valid_org_info(c_org_id in hr_all_organization_units.organization_id%type) IS
5801: Select hoi.org_information_id
5802: from hr_organization_information hoi
5803: where hoi.org_information_context = 'PQP_NL_ABP_PT'
5804: and hoi.org_information3 = to_char(p_pension_type_id)

Line 6507: l_org_id hr_all_organization_units.organization_id%type;

6503: l_ret_val NUMBER;
6504: l_named_hierarchy NUMBER;
6505: l_loop_again NUMBER;
6506: l_eoy_percent hr_organization_information.org_information3%TYPE;
6507: l_org_id hr_all_organization_units.organization_id%type;
6508: l_org_info_id hr_organization_information.org_information_id%type;
6509: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;
6510:
6511: BEGIN