APPS.PQH_ASG_WRAPPER dependencies on DUAL

Line 737: from dual

733: begin
734: l_dummy := null;
735: select 'X'
736: into l_dummy
737: from dual
738: where g_org_hierarchy_root in (
739: SELECT o.organization_id_parent
740: FROM per_org_structure_elements o
741: CONNECT BY o.organization_id_child = PRIOR o.organization_id_parent

Line 797: from dual

793: begin
794: l_dummy := null;
795: select 'X'
796: into l_dummy
797: from dual
798: where g_org_starting_node in (
799: SELECT o.organization_id_parent
800: FROM per_org_structure_elements o
801: CONNECT BY o.organization_id_child = PRIOR o.organization_id_parent

Line 1036: from dual

1032: begin
1033: l_dummy := null;
1034: select 'X'
1035: into l_dummy
1036: from dual
1037: where g_pos_hierarchy_root in (
1038: SELECT o.parent_position_id
1039: FROM per_pos_structure_elements o
1040: CONNECT BY o.subordinate_position_id = PRIOR o.parent_position_id

Line 1095: from dual

1091: begin
1092: l_dummy := null;
1093: select 'X'
1094: into l_dummy
1095: from dual
1096: where g_pos_starting_node in (
1097: SELECT o.parent_position_id
1098: FROM per_pos_structure_elements o
1099: CONNECT BY o.subordinate_position_id = PRIOR o.parent_position_id