DBA Data[Home] [Help]

APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on DUAL

Line 454: from dual

450:
451: begin
452: select 1
453: into l_replace_res
454: from dual
455: where exists (select 1
456: from wip_sub_operation_resources
457: where wip_entity_id = p_wip_entity_id
458: and operation_seq_num = cur_row.operation_seq_num

Line 1816: FROM dual

1812:
1813: BEGIN
1814: SELECT 1
1815: INTO l_op_exists
1816: FROM dual
1817: WHERE EXISTS (SELECT 1
1818: FROM wip_requirement_operations wro
1819: WHERE wro.organization_id = p_organization_id
1820: AND wro.wip_entity_id = p_wip_entity_id

Line 1859: FROM dual

1855:
1856: BEGIN
1857: SELECT 1
1858: INTO l_txn_exists
1859: FROM dual
1860: WHERE EXISTS (SELECT 1
1861: FROM wip_requirement_operations wro
1862: WHERE wro.organization_id = p_organization_id
1863: AND wro.wip_entity_id = p_wip_entity_id