DBA Data[Home] [Help]

APPS.PA_INVOICE_XFER dependencies on DUAL

Line 1342: SELECT p_carrying_out_org_id from dual

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

Line 1348: SELECT p_carrying_out_org_id from dual

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