APPS.PAY_NL_WTS_REPORT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 48: From per_org_structure_versions posv

44: --------------------------------------------------------------------------------------*/
45: FUNCTION Get_org_struct_version_id(p_org_struct_id IN NUMBER,p_month_to IN VARCHAR2) RETURN NUMBER IS
46: cursor Csr_Get_Org_Struct_Version_Id(l_org_struct_id NUMBER,l_month_to VARCHAR2) IS
47: Select org_structure_version_id
48: From per_org_structure_versions posv
49: Where organization_structure_id=l_org_struct_id
50: and to_date(l_month_to,'MMYYYY') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time);
51: l_org_struct_ver_id per_org_structure_versions.org_structure_version_id%TYPE;
52: BEGIN

Line 51: l_org_struct_ver_id per_org_structure_versions.org_structure_version_id%TYPE;

47: Select org_structure_version_id
48: From per_org_structure_versions posv
49: Where organization_structure_id=l_org_struct_id
50: and to_date(l_month_to,'MMYYYY') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time);
51: l_org_struct_ver_id per_org_structure_versions.org_structure_version_id%TYPE;
52: BEGIN
53: OPEN Csr_Get_Org_Struct_Version_Id(p_org_struct_id,p_month_to);
54: FETCH Csr_Get_Org_Struct_Version_Id INTO l_org_struct_ver_id;
55: CLOSE Csr_Get_Org_Struct_Version_Id;