DBA Data[Home] [Help]

APPS.PA_INVOICE_XFER dependencies on DUAL

Line 1340: SELECT p_carrying_out_org_id from dual

1336: -- Cursor is used to select organization sort by level
1337: -- Removed business group id check from CONNECT BY AND START WITH clause
1338:
1339: /* Modifications have been made to the cursor cur_org for BUG#1493157
1340: SELECT p_carrying_out_org_id from dual
1341: union all has been added to select the start organization into the cursor
1342: along with the other organizations that are selected from the connect By query.
1343: The second part of select has been modified so as to select organization_id_parent inplace of organization_id_child */
1344:

Line 1346: SELECT p_carrying_out_org_id from dual

1342: along with the other organizations that are selected from the connect By query.
1343: The second part of select has been modified so as to select organization_id_parent inplace of organization_id_child */
1344:
1345: CURSOR cur_org IS
1346: SELECT p_carrying_out_org_id from dual
1347: union all
1348: SELECT struct.organization_id_parent organization_id
1349: FROM per_org_structure_elements struct
1350: CONNECT BY PRIOR