APPS.PAY_SA_GOSI_REPORTS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 181: from per_org_structure_elements pose

177: l_upper_base VARCHAR2(30);
178: /*Cursor for fetching organizations in the hierarchy*/
179: cursor csr_org_hierarchy is
180: select pose.organization_id_child org
181: from per_org_structure_elements pose
182: connect by pose.organization_id_parent = prior pose.organization_id_child
183: and pose.org_structure_version_id = p_org_structure_version_id
184: start with pose.organization_id_parent = p_organisation_id
185: and pose.org_structure_version_id = p_org_structure_version_id

Line 1267: from per_org_structure_elements pose

1263: l_file_created number := 0;*/
1264: /*Cursor for fetching organizations in the hierarchy*/
1265: cursor csr_org_hierarchy is
1266: select pose.organization_id_child org
1267: from per_org_structure_elements pose
1268: connect by pose.organization_id_parent = prior pose.organization_id_child
1269: and pose.org_structure_version_id = p_org_structure_version_id
1270: start with pose.organization_id_parent = (nvl(p_organisation_id,l_parent_id))
1271: and pose.org_structure_version_id = p_org_structure_version_id

Line 1375: from per_org_structure_elements pose

1371: if p_organisation_id is null then
1372: begin
1373: select distinct pose.organization_id_parent
1374: into l_parent_id
1375: from per_org_structure_elements pose
1376: where pose.org_structure_version_id = p_org_structure_version_id
1377: and pose.organization_id_parent not in (select pose1.organization_id_child
1378: from per_org_structure_elements pose1
1379: where pose1.org_structure_version_id = p_org_structure_version_id);

Line 1378: from per_org_structure_elements pose1

1374: into l_parent_id
1375: from per_org_structure_elements pose
1376: where pose.org_structure_version_id = p_org_structure_version_id
1377: and pose.organization_id_parent not in (select pose1.organization_id_child
1378: from per_org_structure_elements pose1
1379: where pose1.org_structure_version_id = p_org_structure_version_id);
1380: exception
1381: when others then
1382: l_err := 1;

Line 2857: from per_org_structure_elements pose

2853: --and l_effective_date between paf.effective_start_date and paf.effective_end_date;
2854: /*Cursor to get nodes from hierarchy*/
2855: cursor csr_org_hierarchy(p_organisation_id number) is
2856: select pose.organization_id_child org
2857: from per_org_structure_elements pose
2858: connect by pose.organization_id_parent = prior pose.organization_id_child
2859: and pose.org_structure_version_id = p_org_structure_version_id
2860: start with pose.organization_id_parent = p_organisation_id
2861: and pose.org_structure_version_id = p_org_structure_version_id