APPS.PAY_NL_REM_REPORT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 737: l_org_struct_version_id per_org_structure_versions.org_structure_version_id%TYPE;

733:
734: l_xml CLOB;
735: l_start_date DATE;
736: l_valid BOOLEAN;
737: l_org_struct_version_id per_org_structure_versions.org_structure_version_id%TYPE;
738: l_reporting_date DATE;
739: l_reporting_start_date DATE;
740: l_temp_date_to DATE;
741: l_emp_count NUMBER := 0;

Line 880: FROM per_org_structure_versions posv

876: Cursor to get Organization Structure Version id
877: ***********************************************************/
878: CURSOR get_org_struct_version_id(c_org_struct_id IN NUMBER) IS
879: SELECT org_structure_version_id
880: FROM per_org_structure_versions posv
881: WHERE organization_structure_id = c_org_struct_id
882: AND l_reporting_date BETWEEN posv.date_from
883: AND nvl (posv.date_to
884: ,hr_general.end_of_time);