APPS.PER_PAYRPEMV_XMLP_PKG SQL Statements

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

Line: 79

      '(select to_char(pose.organization_id_child) '||
       'from per_org_structure_elements pose '||
       'connect by pose.organization_id_parent = '||
       'prior pose.organization_id_child '||
       'and pose.org_structure_version_id = '||
       to_char(p_org_structure_version_id) ||
      ' start with pose.organization_id_parent = '||
         to_char(p_parent_organization_id) ||
      ' and pose.org_structure_version_id = '||
       to_char(p_org_structure_version_id) ||
      ' union select ' ||''''||
       to_char(p_parent_organization_id) ||''''||
      ' from sys.dual) ';

Line: 96

      '(select to_char(pose.organization_id_child) '||
       'from per_org_structure_elements pose '||
       'connect by pose.organization_id_parent = '||
       'prior pose.organization_id_child '||
       'and pose.org_structure_version_id = '||
       to_char(p_org_structure_version_id) ||
      ' start with pose.organization_id_parent = '||
         to_char(p_parent_organization_id) ||
      ' and pose.org_structure_version_id = '||
       to_char(p_org_structure_version_id) ||
      ' union select ' ||''''||
       to_char(p_parent_organization_id) ||''''||
      ' from sys.dual) ';

Line: 112

      '(select to_char(pose.organization_id_child) '||
       'from per_org_structure_elements pose '||
       'connect by pose.organization_id_parent = '||
       'prior pose.organization_id_child '||
       'and pose.org_structure_version_id = '||
       to_char(p_org_structure_version_id) ||
      ' start with pose.organization_id_parent = '||
         to_char(p_parent_organization_id) ||
      ' and pose.org_structure_version_id = '||
       to_char(p_org_structure_version_id) ||
      ' union select ' ||''''||
       to_char(p_parent_organization_id) ||''''||
      ' from sys.dual) ';

Line: 143

 	'( select organization_id_child '||
	'from per_org_structure_elements '||
	'where org_structure_version_id = '||
	to_char(p_org_structure_version_id) ||
	' union '||
	'select distinct organization_id_parent '||
	'from per_org_structure_elements '||
	'where org_structure_version_id = '||
	to_char(p_org_structure_version_id) ||')';

Line: 155

 	'( select organization_id_child '||
	'from per_org_structure_elements '||
	'where org_structure_version_id = '||
	to_char(p_org_structure_version_id) ||
	' union '||
	'select distinct organization_id_parent '||
	'from per_org_structure_elements '||
	'where org_structure_version_id = '||
	to_char(p_org_structure_version_id) ||')';

Line: 167

 	'( select organization_id_child '||
	'from per_org_structure_elements '||
	'where org_structure_version_id = '||
	to_char(p_org_structure_version_id) ||
	' union '||
	'select distinct organization_id_parent '||
	'from per_org_structure_elements '||
	'where org_structure_version_id = '||
	to_char(p_org_structure_version_id) ||')';

Line: 294

select	hrl.meaning
into	l_emp_det_param
from	hr_lookups hrl
where	p_employee_detail = hrl.lookup_code
and	hrl.lookup_type = 'PAYRPEMV_EMP_DET';

Line: 306

   select	hrl.meaning
   into	CP_WORKER_TYPE_DESC
   from	hr_lookups hrl
   where	p_worker_type = hrl.lookup_code
   and	hrl.lookup_type = 'HR_HEADCOUNT_WORKER_TYPE';