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 1104: -- END Dual maintenance section with CSTPACCB.pls

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

Line 1339: FROM dual

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

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

1737:
1738:
1739:
1740: --------------------------------------------------------------
1741: -- BEGIN Dual maintenance section with CSTPACCB.pls
1742: --------------------------------------------------------------
1743:
1744: l_stmt_num := 120;
1745:

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

2025: HAVING
2026: SUM(nvl(temp_relieved_value,0)) <> 0;
2027:
2028: --------------------------------------------------------------
2029: -- BEGIN Dual maintenance section with CSTPACCB.pls
2030: --------------------------------------------------------------
2031:
2032: END IF;
2033: