APPS.CSTPLCAC dependencies on DUAL

Line 231: FROM dual

227: */
228:
229: SELECT COUNT(1)
230: INTO l_wro_count
231: FROM dual
232: WHERE EXISTS ( SELECT NULL
233: FROM wip_requirement_operations wro
234: WHERE wro.wip_entity_id = i_wip_entity_id
235: AND wro.quantity_per_assembly <>0

Line 740: -- BEGIN Dual maintenance section with CSTPACCB.pls

736: END LOOP; -- wro_cursor
737:
738:
739: --------------------------------------------------------------
740: -- BEGIN Dual maintenance section with CSTPACCB.pls
741: --------------------------------------------------------------
742:
743: -----------------------------------------------------------
744: -- Relieve This Level Resource costs/units from WIP ...

Line 1102: -- END Dual maintenance section with CSTPACCB.pls

1098: SUM(nvl(temp_relieved_value,0)) <> 0;
1099:
1100:
1101: --------------------------------------------------------------
1102: -- END Dual maintenance section with CSTPACCB.pls
1103: --------------------------------------------------------------
1104:
1105:
1106: END IF; -- main IF

Line 1336: FROM dual

1332: and quantity_per_assembly <>0;
1333: */
1334: SELECT COUNT(1)
1335: INTO l_wro_count
1336: FROM dual
1337: WHERE EXISTS ( SELECT NULL
1338: FROM wip_requirement_operations wro
1339: WHERE wro.wip_entity_id = i_wip_entity_id
1340: AND wro.quantity_per_assembly <>0

Line 1738: -- BEGIN Dual maintenance section with CSTPACCB.pls

1734:
1735:
1736:
1737: --------------------------------------------------------------
1738: -- BEGIN Dual maintenance section with CSTPACCB.pls
1739: --------------------------------------------------------------
1740:
1741: l_stmt_num := 120;
1742:

Line 2024: -- BEGIN Dual maintenance section with CSTPACCB.pls

2020: HAVING
2021: SUM(nvl(temp_relieved_value,0)) <> 0;
2022:
2023: --------------------------------------------------------------
2024: -- BEGIN Dual maintenance section with CSTPACCB.pls
2025: --------------------------------------------------------------
2026:
2027: END IF;
2028: