APPS.PER_JP_REPORT_COMMON_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

    SELECT organization_id
    FROM   hr_all_organization_units
    WHERE  business_group_id=p_business_group_id
	AND    organization_id NOT IN(SELECT business_group_id
	                             FROM hr_organization_units
								 WHERE business_group_id=p_business_group_id);

Line: 61

    SELECT DISTINCT POSE.organization_id_child organization_id
    FROM   per_org_structure_elements POSE
	      ,per_organization_structures POS
	      ,per_org_structure_versions POSV
    WHERE  POSE.business_group_id                 = p_business_group_id
    AND    p_include_org_hierarchy                = 'Y'
    AND    POSV.org_structure_version_id = POSE.org_structure_version_id
	AND    POS.primary_structure_flag='Y'
	AND    POS.organization_structure_id = POSV.organization_structure_id
    START   WITH POSE.organization_id_parent      = p_organization_id
    CONNECT BY PRIOR POSE.organization_id_child   = POSE.organization_id_parent;